I'd like to get a discussion going on what is, in my opinion, a rarely discussed topic - gathering data by hand for use in the
tidyverse. A lot of the data I work with is collected by hand - either smaller one-time projects or recurring data collection over months/years.
So far it's been a pretty messy mixture of Excel, Google Sheets, editing csv files in a text editor and sometimes using
add_row() in R. It works but I'd love to simplify and streamline the process. The
googlesheets package seems very useful but I haven't yet used it extensively.
So here are my more specific hypothetical questions:
- If you were to gather data on the t-shirts that you own, say, colour, size, age, if there's something printed on it etc - how would you do it?
- If you were to write down the colours of the first 50 cars driving past your window every Monday for a year - how would you do it?
I'm assuming manual data entry for these. Sure, technically you could take pictures of the shirts and ML some of the data or set up a webcam to track the car colours. But let's say we have to do it by hand.
Any other tips, tricks or experiences you have to share, I'd love to hear that too.
All the best!