purple-air
question:purple-air

Redirect...


Author Comment Last activity Moderation
Bronwen "This is a really interesting question! I know that the plantower sensors are affected by vapor, humidity, aerosols, though how comparable those res..." | Read more » over 2 years ago
guolivar "Normalising is your friend when you have things with very different ranges. Depending on what you're looking for you can divide each column by its ..." | Read more » over 2 years ago
eustatic "Pivot tables? Lookup or index command? Conditional formatting? all of these things can help. i had to have 10 years and 14 plant plot growth s..." | Read more » almost 3 years ago
warren "I also noticed that some very high values make others basically unreadable. So having 2 y-axis scales can sometimes help, i guess, although that's ..." | Read more » almost 3 years ago
warren "Thanks! Yes, i started by removing things like firmware #, for sure. It's interesting to see how some values track each other roughly, while others..." | Read more » almost 3 years ago
guolivar "This is very much dataset, project and software dependent. Sometimes I remove columns, other times I combine them (averaging, adding, etc), other ..." | Read more » almost 3 years ago
warren "Hi @stevie, @Aleah, @Cbarnes9, and @crispinpierce, I posted this in follow up after the purple air datalogs ended up so dense and tough to read! Th..." | Read more » almost 3 years ago
warren "OK, i got the units to show. I trimmed back one file to just a few of the columns, just to make it more readable, but it doesn't have all the diffe..." | Read more » almost 3 years ago
warren "If you'd like, I can change it to just links for download! But it was interesting to see the data a bit in a graph. There are just so many fields, ..." | Read more » almost 3 years ago
warren "Hi, all, drag-and-drop for big CSVs is working again now. The graph that's generated is a bit wild because there are so many fields. But there is a..." | Read more » almost 3 years ago
stevie "Hi Jeff I have them, I also tried to get them up. I'll send them to you. " | Read more » almost 3 years ago
warren "Crispin, could you email me the CSVs you're working with at jeff@publiclab.org so we can debug a bit? And, you had tried uploading them here in the..." | Read more » almost 3 years ago
warren "Hi @crispinpierce - are the 50 csv files each a 24-hour datalog? I'm going to test out uploading a CSV to help debug here, too, so hang on a sec: ..." | Read more » almost 3 years ago
crispinpierce "@jefffalk, @stevie, @Aleah, @Cbarnes9. A script that would remove the first row (column headers) and combine 50 csv files into a single Excel workb..." | Read more » almost 3 years ago
tranglixi88 " Cách vào tiền dàn đề online Trong đánh lô đề, soi cầu chuẩn mỗi ngày quyết định việc thắ..." | Read more » almost 3 years ago
crispinpierce " Hi Stevie, Thanks for the quick follow-up. I had two windows open: the PublicLab conversation and the folder with the files. I dragged the files..." | Read more » almost 3 years ago
warren "There is also a "recover comment" button shown with a disk icon in the editor; it may still have your text? On Tue, Aug 27, 2019 at 10:00 AM \<..." | Read more » almost 3 years ago
liz "We might also find a time to jump on a video call, and do some screensharing to get on the same page (literally) and make some progress! Every Tues..." | Read more » almost 3 years ago
jeffalk "Hi @stevie, @Aleah, @Cbarnes9, and @crispinpierce, I may be jumping the gun here but since .csv files are openable by EXCEL and can be copied and ..." | Read more » almost 3 years ago
stevie "Hi Crispin - about getting these files up, sorry you're having trouble. Curious, are you dragging them into your email in reply or directly onto th..." | Read more » almost 3 years ago
crispinpierce "@stevie, @warren, @jeffalk, @Aleah and @Cbarnes9. Our issue with the data files is to be able to amalgamate numerous 24-hour csv files that are wri..." | Read more » almost 3 years ago
crispinpierce "@stevie, @warren, @jeffalk, @Aleah and @Cbarnes9. Our issue with the data files is to be able to amalgamate numerous 24-hour csv files that are wri..." | Read more » almost 3 years ago
liz "Thank you very much @jeffalk ! Great narrative. " | Read more » almost 3 years ago
jeffalk "Hello @liz; That might help if the someone, like me, had sense enough to look at the buttons down at the bottom (as I did not!). Here I'll try a..." | Read more » almost 3 years ago