Icon

Challenge 16 - Find worst months of allergens based on history for Austin, Texas

<p><strong>Challenge 16 - Finding the Worst Months for Allergies</strong></p><p><strong>Level:</strong> Easy<br><br><strong>Description:&nbsp;</strong>You are planning on moving to Austin, Texas, but you suffer from allergies. You want to find out which months would be the worst in the year for you in your new city. Can some data analytics help you uncover allergen patterns in Austin, starting from 2005?<br><br><em>Beginner-friendly objectives: </em>1.: Read in dataset and filter for only Travis, TX, PM2.5, and convert the date column properly. Focus only on data from 2005-01-01 and up. 2. Group the data by month and visualize average monthly AQI. 3. Get the yearly average of AQI and check for which months values are typically higher than it. Produce a data table showing which months are above the yearly AQI average for Travis County (Austin, TX).</p>

URL: dataset https://www.kaggle.com/datasets/threnjen/40-years-of-air-quality-index-from-the-epa-daily/data

Obj. 1 (Easy): Read in dataset and filter for only Travis, TX, PM2.5, and convert date column properly

Obj. 2 (Easy): Group data by month and visualize average monthly AQI

Obj. 3 (Easy): Get the yearly average of AQI and check which months are typically higher than it. produce a data table showing which months are above the yearly AQI average for Travis County (Austin, TX)

Challenge 16 - Finding the Worst Months for Allergies


Level: Easy

Description: You are planning on moving to Austin, Texas, but you suffer from allergies. You want to find out which months would be the worst in the year for you in your new city. Can some data analytics help you uncover allergen patterns in Austin, starting from 2005?

Beginner-friendly objectives: 1.: Read in dataset and filter for only Travis, TX, PM2.5, and convert the date column properly. Focus only on data from 2005-01-01 and up. 2. Group the data by month and visualize average monthly AQI. 3. Get the yearly average of AQI and check for which months values are typically higher than it. Produce a data table showing which months are above the yearly AQI average for Travis County (Austin, TX).

Read in kaggledataset on AQI
CSV Reader
Filter for Travis County, Texas
Row Filter
populate AQI downthe missing values
Missing Value
We only wantPM2.5 and data from 2005and up
Row Filter
extract year and month
Date&Time Part Extractor
Add new col.True if monthly avg > yearly avg
Expression
Visualize the average AQIper month
Bar Chart
display worst months
Table View
Group by month
GroupBy
Dict of month num --> name
Table Creator
aggregate mean aqifor the year
GroupBy
convert Date colfrom string
String to Date&Time
convert month
Number to String
only higher thanyearly avg
Row Filter
convert month numberback to name
Value Lookup
join yearlyavg into bottomtable
Joiner
convert all monthto 1 so we cancalc avg AQI yearly
Expression
rename aggregatecol to AQI Yearly Avg
Column Renamer

Nodes

Extensions

Links