Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

bartleby

Concept explainers

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 the two emissions called PM2.5-Attributable Respiratory Hospitalizations (Adults 20 Yrs and Older)  and PM2.5-Attributable Respiratory Hospitalizations (Adults 40 Yrs and Older)within the column and prints out which city has the respiratory hospitalizations for both 20 years and older and 40 years and older based on a column called 'Data Value'

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

1
2
3
4
5
CO
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
A
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
B
Indicator ID
C
Name
386 Ozone (03)
386 Ozone (03)
D
E
Measure Info
ppb
ppb
ppb
ppb
ppb
ppb
ppb
ppb
ppb
ppb
ppb
ppb
F
G
Geo Type Name Geo Join ID
CD
CD
Measure
Mean
Mean
386 Ozone (03)
Mean
386 Ozone (03)
Mean
383 Sulfur Dioxide (S Mean
383 C11558 oxide (S Mean
386 PM2.5-Attributable Respiratory Hospitalizations (Adults 20 Yrs and Older)
386 Ozone (03)
Mean
Borough
383 Sulfur Dioxide (S Mean
383 Sulfur Dioxide (S Mean
383 Sulfur Dioxide (S Mean
383 Sulfur Dioxide (S Mean
383 Sulfur Dioxide (S Mean
383 Sulfur Dioxide (S Mean
383 Sulfur Dioxide (S Mean
ppb
ppb
ppb
383 Sulfur Dioxide (S Mean
386 Ozone (03) Mean
386 Ozone (03)
ppb
Mean
ppb
386 Ozone (03)
Mean
ppb
386 Ozone (03)
Mean
ppb
383 Sulfur Dioxide (S Mean
ppb
ppb
383 Sulfur Dioxide (S Mean
639 PM2.5-Attributak Estimated Annua per 100,000 adu UHF42
639 PM2.5-Attributat Estimated Annua per 100,000 adu UHF42
639 PM2.5-Attributat Estimated Annua per 100,000 adu UHF42
639 PM2.5-Attributat Estimated Annua per 100,000 adu UHF42
639 PM2. Mail at Estimated Annua per 100,000 adu UHF42
639 PM2 5-AtMbutat Estimated Annu: per 100.000 adu UHF42
Borough
Borough
CD
CD
CD
CD
CD
CD
CD
CD
CD
CD
Borough
Borough
Borough
Borough
CD
CD
H
I
Geo Place Name Time Period
313 Coney Island (CI Summer 2013
313 Coney Island (C) Summer 2014
1 Bronx
Summer 2013
Summer 2014
1 Bronx
211 Morris Park and Winter 2008-09
212 Williamsbridge a Winter 2008-09
2 Brooklyn
2 Brooklyn
Summer 2009
Summer 2010
301 Greenpoint and Winter 2008-09
302 Fort Greene and Winter 2008-09
303 Bedford Stuyves Winter 2008-09
304 Bushwick (CD4) Winter 2008-09
305 East New York a Winter 2008-09
306 Park Slope and Winter 2008-09
307 Sunset Park (CD Winter 2008-09
308 Crown Heights a Winter 2008-09
2 Brooklyn
Summer 2011
2 Brooklyn
Summer 2012
2 Brooklyn
Summer 2013
2 Brooklyn
Summer 2014
206 Belmont and Ea: Winter 2009-10
207 Kingsbridge Heig Winter 2009-10
101 Kingsbridge - Ri 2005-2007
102 Northeast Bronx 2005-2007
103 Fordham - Bron> 2005-2007
104 Pelham - Throgs 2005-2007
105 Crotona -Tremor 2005-2007
106 High Bridge - Mc 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
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
L
Message
expand button
Transcribed Image Text:1 2 3 4 5 CO 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 A 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 B Indicator ID C Name 386 Ozone (03) 386 Ozone (03) D E Measure Info ppb ppb ppb ppb ppb ppb ppb ppb ppb ppb ppb ppb F G Geo Type Name Geo Join ID CD CD Measure Mean Mean 386 Ozone (03) Mean 386 Ozone (03) Mean 383 Sulfur Dioxide (S Mean 383 C11558 oxide (S Mean 386 PM2.5-Attributable Respiratory Hospitalizations (Adults 20 Yrs and Older) 386 Ozone (03) Mean Borough 383 Sulfur Dioxide (S Mean 383 Sulfur Dioxide (S Mean 383 Sulfur Dioxide (S Mean 383 Sulfur Dioxide (S Mean 383 Sulfur Dioxide (S Mean 383 Sulfur Dioxide (S Mean 383 Sulfur Dioxide (S Mean ppb ppb ppb 383 Sulfur Dioxide (S Mean 386 Ozone (03) Mean 386 Ozone (03) ppb Mean ppb 386 Ozone (03) Mean ppb 386 Ozone (03) Mean ppb 383 Sulfur Dioxide (S Mean ppb ppb 383 Sulfur Dioxide (S Mean 639 PM2.5-Attributak Estimated Annua per 100,000 adu UHF42 639 PM2.5-Attributat Estimated Annua per 100,000 adu UHF42 639 PM2.5-Attributat Estimated Annua per 100,000 adu UHF42 639 PM2.5-Attributat Estimated Annua per 100,000 adu UHF42 639 PM2. Mail at Estimated Annua per 100,000 adu UHF42 639 PM2 5-AtMbutat Estimated Annu: per 100.000 adu UHF42 Borough Borough CD CD CD CD CD CD CD CD CD CD Borough Borough Borough Borough CD CD H I Geo Place Name Time Period 313 Coney Island (CI Summer 2013 313 Coney Island (C) Summer 2014 1 Bronx Summer 2013 Summer 2014 1 Bronx 211 Morris Park and Winter 2008-09 212 Williamsbridge a Winter 2008-09 2 Brooklyn 2 Brooklyn Summer 2009 Summer 2010 301 Greenpoint and Winter 2008-09 302 Fort Greene and Winter 2008-09 303 Bedford Stuyves Winter 2008-09 304 Bushwick (CD4) Winter 2008-09 305 East New York a Winter 2008-09 306 Park Slope and Winter 2008-09 307 Sunset Park (CD Winter 2008-09 308 Crown Heights a Winter 2008-09 2 Brooklyn Summer 2011 2 Brooklyn Summer 2012 2 Brooklyn Summer 2013 2 Brooklyn Summer 2014 206 Belmont and Ea: Winter 2009-10 207 Kingsbridge Heig Winter 2009-10 101 Kingsbridge - Ri 2005-2007 102 Northeast Bronx 2005-2007 103 Fordham - Bron> 2005-2007 104 Pelham - Throgs 2005-2007 105 Crotona -Tremor 2005-2007 106 High Bridge - Mc 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 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 L Message
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Computer Science
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
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education