# Basic data analysis?
**URL:** https://community.purpleair.com/t/basic-data-analysis/3742
**Category:** Data
**Created:** [February 25, 2023, 5:54pm UTC](https://community.purpleair.com/t/basic-data-analysis/3742 "2023-02-25T17:54:40Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@spike](https://community.purpleair.com/u/spike)
#### Post date: [February 25, 2023, 5:54pm UTC](https://community.purpleair.com/t/basic-data-analysis/3742/1 "2023-02-25T17:54:40Z")
Hi, does anyone have instructions for basic data analysis? I’ve been told pivot tables would help me compare weekday and weekend data at a site, but I’m also interested in comparing two sites during the same time period. I’ve looked up how to perform pivot tables, but it’s not clear to me how this applies to AQ. Thanks.
---
### Author:  [@Chandra\_Prakash](https://community.purpleair.com/u/Chandra_Prakash)
#### Post date: [August 6, 2026, 8:20pm UTC](https://community.purpleair.com/t/basic-data-analysis/3742/2 "2026-08-06T20:20:44Z")
I kept opening my PurpleAir CSV files and closing them again - thousands of rows, no idea what my air actually looked like.
So I built a free tool to fix that for myself. Drop in your export, get EPA-corrected PM2.5, quality checks, your daily patterns, and a perfect report which can explain the QA/QC analysis and gives you perfect visuals to understand your data. Runs in your browser, nothing stored.
It helped me a lot. Hope it helps you too 👇
[https://cpchoudhary2024-airquality-analyzer.hf.space](https://cpchoudhary2024-airquality-analyzer.hf.space/)
#PurpleAir #airquality #PM25