Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
There is a csv file called Air_Quality.csv. It has 12 columns and 17,000 rows. One column titled 'Name' which has a various emissions listed in it. Another column titled 'Geo Place Name' has a list of cities. Write a code (in the most basic Python) which finds an emission called Traffic Density within the column and prints out which city has the most Traffic Density based on a column called 'Data Value'

There is a csv file called Air_Quality.csv. It has 12 columns and 17,000 rows. One column titled 'Name' which has a various emissions listed in it. Another column titled 'Geo Place Name' has a list of cities. Write a code (in the most basic Python) which finds an emission called Traffic Density within the column and prints out which city has the most Traffic Density based on a column called 'Data Value'

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

There is a csv file called Air_Quality.csv. It has 12 columns and 17,000 rows. One column titled 'Name' which has a various emissions listed in it. Another column titled 'Geo Place Name' has a list of cities. Write a code (in the most basic Python) which finds an emission called Traffic Density within the column and prints out which city has the most Traffic Density based on a column called 'Data Value'

Below is a picture of a small chunk of the csv file.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 Unique ID 216498 216499 219969 219970 164876 164877 219971 219972 164878 164879 164880 164881 164882 164883 164884 164885 219973 219974 219975 219976 164930 164931 130355 130356 130357 130358 130359 130360 130361 130362 130363 130364 130365 130366 130367 130368 130369 130370 130371 130372 B Indicator ID E Measure Info ppb ppb ppb ppb ppb Name Measure 386 Ozone (03) Mean 386 Ozone (03) Mean 386 Ozone (03) Mean 386 Ozone (03) Mean 383 Sulfur Dioxide (SO2) Mean 383 Sulfur Dioxide (SO2) Mean 386 Ozone (03) Mean 386 Ozone (03) Mean 383 Sulfur Dioxide (SO2) Mean 383 Sulfur Dioxide (SO2) Mean 383 Sulfur Dioxide (SO2) Mean 383 Sulfur Dioxide (SO2) Mean 383 Sulfur Dioxide (SO2) Mean 383 Sulfur Dioxide (SO2) Mean 383 Sulfur Dioxide (SO2) Mean ppb 383 Sulfur Dioxide (SO2) Mean 386 Ozone (03) Mean ppb 386 Ozone (03) Mean ppb 386 Ozone (03) Mean ppb 386 Ozone (03) Mean ppb 383 Sulfur Dioxide (SO2) Mean ppb 383 Sulfur Dioxide (SO2) Mean ppb 639 PM2.5-Attributable D Estimated Annual Re per 100,000 adults UHF42 639 PM2.5-Attributable C Estimated Annual Ra per 100,000 adults UHF42 639 PM2.5-Attributable D Estimated Annual Ra per 100,000 adults UHF42 639 PM2.5-Attributable D Estimated Annual Ra per 100,000 adults UHF42 639 PM2.5-Attributable C Estimated Annual Re per 100,000 adults UHF42 639 PM2.5-Attributable C Estimated Annual Ra per 100,000 adults UHF42 639 PM2.5-Attributable D Estimated Annual Ra per 100,000 adults UHF42 639 PM2.5-Attributable C Estimated Annual Re per 100,000 adults UHF42 639 PM2.5-Attributable D Estimated Annual Ra per 100,000 adults UHF42 639 PM2.5-Attributable C Estimated Annual Ra per 100,000 adults UHF42 639 PM2.5-Attributable D Estimated Annual Ra per 100,000 adults UHF42 639 PM2.5-Attributable C Estimated Annual Ra per 100,000 adults UHF42 639 PM2.5-Attributable D Estimated Annual Ra per 100,000 adults UHF42 639 PM2.5-Attributable D Estimated Annual Ra per 100,000 adults UHF42 639 PM2.5-Attributable D Estimated Annual Ra per 100,000 adults UHF42 639 PM2.5-Attributable D Estimated Annual Re per 100,000 adults UHF42 639 PM2.5-Attributable D Estimated Annual Ra per 100,000 adults UHF42 639 PM2.5-Attributable C Estimated Annual Ra per 100,000 adults UHF42 ppb ppb ppb ppb ppb ppb ppb ppb ppb ppb Geo Type Name CD CD Borough Borough CD CD Borough Borough CD CD CD CD CD CD CD CD Borough Borough Borough Borough F CD CD Geo Join ID H Geo Place Name Time Period 313 Coney Island (CD13) Summer 2013 313 Coney Island (CD13) Summer 2014 1 Bronx Summer 2013 Summer 2014 1 Bronx 211 Morris Park and Bron Winter 2008-09 212 Williamsbridge and E Winter 2008-09 2 Brooklyn Summer 2009 Summer 2010 2 Brooklyn 2 Brooklyn 301 Greenpoint and Willi Winter 2008-09 302 Fort Greene and Bro Winter 2008-09 303 Bedford Stuyvesant (Winter 2008-09 304 Bushwick (CD4) Winter 2008-09 305 East New York and S Winter 2008-09 306 Park Slope and Carr Winter 2008-09 307 Sunset Park (CD7) Winter 2008-09 308 Crown Heights and P Winter 2008-09 2 Brooklyn Summer 2011 Summer 2012 2 Brooklyn Summer 2013 2 Brooklyn Summer 2014 206 Belmont and East Tr Winter 2009-10 207 Kingsbridge Heights Winter 2009-10 101 Kingsbridge - Riverda 2005-2007 102 Northeast Bronx 2005-2007 103 Fordham - Bronx Pk 2005-2007 104 Pelham Throgs Nec 2005-2007 105 Crotona -Tremont 2005-2007 106 High Bridge - Morrisa 2005-2007 107 Hunts Point - Mott Ha 2005-2007 201 Greenpoint 2005-2007 202 Downtown - Heights - 2005-2007 203 Bedford Stuyvesant - 2005-2007 204 East New York 2005-2007 205 Sunset Park 2005-2007 206 Borough Park 2005-2007 207 East Flatbush - Flatb 2005-2007 208 Canarsie - Flatlands 2005-2007 209 Bensonhurst - Bay Ri 2005-2007 210 Coney Island - Sheep 2005-2007 211 Williamsburg - Bushv 2005-2007 J Start Date 6/1/2013 6/1/2014 6/1/2013 6/1/2014 12/1/2008 12/1/2008 6/1/2009 6/1/2010 12/1/2008 12/1/2008 12/1/2008 12/1/2008 12/1/2008 12/1/2008 12/1/2008 12/1/2008 6/1/2011 6/1/2012 6/1/2013 6/1/2014 12/1/2009 12/1/2009 1/1/2005 1/1/2005 1/1/2005 1/1/2005 1/1/2005 1/1/2005 1/1/2005 1/1/2005 1/1/2005 1/1/2005 1/1/2005 1/1/2005 1/1/2005 1/1/2005 1/1/2005 1/1/2005 1/1/2005 1/1/2005 K Data Value 34.64 33.22 31.25 31.15 5.89 5.75 26.27 33.83 4.33 4.41 4.73 4.71 3.78 3.94 3.78 4.79 33.19 33.89 31.13 31.29 5.3 7.49 117.7 77.3 67.3 73.6 65.8 84.8 71 64 58.9 80 64.1 49.2 68.2 54.9 61.1 73.4 83.3 72.2 Message L
Transcribed Image Text:1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 Unique ID 216498 216499 219969 219970 164876 164877 219971 219972 164878 164879 164880 164881 164882 164883 164884 164885 219973 219974 219975 219976 164930 164931 130355 130356 130357 130358 130359 130360 130361 130362 130363 130364 130365 130366 130367 130368 130369 130370 130371 130372 B Indicator ID E Measure Info ppb ppb ppb ppb ppb Name Measure 386 Ozone (03) Mean 386 Ozone (03) Mean 386 Ozone (03) Mean 386 Ozone (03) Mean 383 Sulfur Dioxide (SO2) Mean 383 Sulfur Dioxide (SO2) Mean 386 Ozone (03) Mean 386 Ozone (03) Mean 383 Sulfur Dioxide (SO2) Mean 383 Sulfur Dioxide (SO2) Mean 383 Sulfur Dioxide (SO2) Mean 383 Sulfur Dioxide (SO2) Mean 383 Sulfur Dioxide (SO2) Mean 383 Sulfur Dioxide (SO2) Mean 383 Sulfur Dioxide (SO2) Mean ppb 383 Sulfur Dioxide (SO2) Mean 386 Ozone (03) Mean ppb 386 Ozone (03) Mean ppb 386 Ozone (03) Mean ppb 386 Ozone (03) Mean ppb 383 Sulfur Dioxide (SO2) Mean ppb 383 Sulfur Dioxide (SO2) Mean ppb 639 PM2.5-Attributable D Estimated Annual Re per 100,000 adults UHF42 639 PM2.5-Attributable C Estimated Annual Ra per 100,000 adults UHF42 639 PM2.5-Attributable D Estimated Annual Ra per 100,000 adults UHF42 639 PM2.5-Attributable D Estimated Annual Ra per 100,000 adults UHF42 639 PM2.5-Attributable C Estimated Annual Re per 100,000 adults UHF42 639 PM2.5-Attributable C Estimated Annual Ra per 100,000 adults UHF42 639 PM2.5-Attributable D Estimated Annual Ra per 100,000 adults UHF42 639 PM2.5-Attributable C Estimated Annual Re per 100,000 adults UHF42 639 PM2.5-Attributable D Estimated Annual Ra per 100,000 adults UHF42 639 PM2.5-Attributable C Estimated Annual Ra per 100,000 adults UHF42 639 PM2.5-Attributable D Estimated Annual Ra per 100,000 adults UHF42 639 PM2.5-Attributable C Estimated Annual Ra per 100,000 adults UHF42 639 PM2.5-Attributable D Estimated Annual Ra per 100,000 adults UHF42 639 PM2.5-Attributable D Estimated Annual Ra per 100,000 adults UHF42 639 PM2.5-Attributable D Estimated Annual Ra per 100,000 adults UHF42 639 PM2.5-Attributable D Estimated Annual Re per 100,000 adults UHF42 639 PM2.5-Attributable D Estimated Annual Ra per 100,000 adults UHF42 639 PM2.5-Attributable C Estimated Annual Ra per 100,000 adults UHF42 ppb ppb ppb ppb ppb ppb ppb ppb ppb ppb Geo Type Name CD CD Borough Borough CD CD Borough Borough CD CD CD CD CD CD CD CD Borough Borough Borough Borough F CD CD Geo Join ID H Geo Place Name Time Period 313 Coney Island (CD13) Summer 2013 313 Coney Island (CD13) Summer 2014 1 Bronx Summer 2013 Summer 2014 1 Bronx 211 Morris Park and Bron Winter 2008-09 212 Williamsbridge and E Winter 2008-09 2 Brooklyn Summer 2009 Summer 2010 2 Brooklyn 2 Brooklyn 301 Greenpoint and Willi Winter 2008-09 302 Fort Greene and Bro Winter 2008-09 303 Bedford Stuyvesant (Winter 2008-09 304 Bushwick (CD4) Winter 2008-09 305 East New York and S Winter 2008-09 306 Park Slope and Carr Winter 2008-09 307 Sunset Park (CD7) Winter 2008-09 308 Crown Heights and P Winter 2008-09 2 Brooklyn Summer 2011 Summer 2012 2 Brooklyn Summer 2013 2 Brooklyn Summer 2014 206 Belmont and East Tr Winter 2009-10 207 Kingsbridge Heights Winter 2009-10 101 Kingsbridge - Riverda 2005-2007 102 Northeast Bronx 2005-2007 103 Fordham - Bronx Pk 2005-2007 104 Pelham Throgs Nec 2005-2007 105 Crotona -Tremont 2005-2007 106 High Bridge - Morrisa 2005-2007 107 Hunts Point - Mott Ha 2005-2007 201 Greenpoint 2005-2007 202 Downtown - Heights - 2005-2007 203 Bedford Stuyvesant - 2005-2007 204 East New York 2005-2007 205 Sunset Park 2005-2007 206 Borough Park 2005-2007 207 East Flatbush - Flatb 2005-2007 208 Canarsie - Flatlands 2005-2007 209 Bensonhurst - Bay Ri 2005-2007 210 Coney Island - Sheep 2005-2007 211 Williamsburg - Bushv 2005-2007 J Start Date 6/1/2013 6/1/2014 6/1/2013 6/1/2014 12/1/2008 12/1/2008 6/1/2009 6/1/2010 12/1/2008 12/1/2008 12/1/2008 12/1/2008 12/1/2008 12/1/2008 12/1/2008 12/1/2008 6/1/2011 6/1/2012 6/1/2013 6/1/2014 12/1/2009 12/1/2009 1/1/2005 1/1/2005 1/1/2005 1/1/2005 1/1/2005 1/1/2005 1/1/2005 1/1/2005 1/1/2005 1/1/2005 1/1/2005 1/1/2005 1/1/2005 1/1/2005 1/1/2005 1/1/2005 1/1/2005 1/1/2005 K Data Value 34.64 33.22 31.25 31.15 5.89 5.75 26.27 33.83 4.33 4.41 4.73 4.71 3.78 3.94 3.78 4.79 33.19 33.89 31.13 31.29 5.3 7.49 117.7 77.3 67.3 73.6 65.8 84.8 71 64 58.9 80 64.1 49.2 68.2 54.9 61.1 73.4 83.3 72.2 Message L
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Constants and Variables
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS