rizona  AZ          West    6392017   232 4              Arkansas  AR         S

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
icon
Related questions
Question

Show summary of statistics by region using summary() and groupby() function.

                  state abb        region population total

1               Alabama  AL         South    4779736   135

2                Alaska  AK          West     710231    19

3               Arizona  AZ          West    6392017   232

4              Arkansas  AR         South    2915918    93

5            California  CA          West   37253956  1257

6              Colorado  CO          West    5029196    65

7           Connecticut  CT     Northeast    3574097    97

8              Delaware  DE         South     897934    38

9  District of Columbia  DC         South     601723    99

10              Florida  FL         South   19687653   669

11              Georgia  GA         South    9920000   376

12               Hawaii  HI          West    1360301     7

13                Idaho  ID          West    1567582    12

14             Illinois  IL North Central   12830632   364

15              Indiana  IN North Central    6483802   142

16                 Iowa  IA North Central    3046355    21

17               Kansas  KS North Central    2853118    63

18             Kentucky  KY         South    4339367   116

19            Louisiana  LA         South    4533372   351

20                Maine  ME     Northeast    1328361    11

21             Maryland  MD         South    5773552   293

22        Massachusetts  MA     Northeast    6547629   118

23             Michigan  MI North Central    9883640   413

24            Minnesota  MN North Central    5303925    53

25          Mississippi  MS         South    2967297   120

26             Missouri  MO North Central    5988927   321

27              Montana  MT          West     989415    12

28             Nebraska  NE North Central    1826341    32

29               Nevada  NV          West    2700551    84

30        New Hampshire  NH     Northeast    1316470     5

31           New Jersey  NJ     Northeast    8791894   246

32           New Mexico  NM          West    2059179    67

33             New York  NY     Northeast   19378102   517

34       North Carolina  NC         South    9535483   286

35         North Dakota  ND North Central     672591     4

36                 Ohio  OH North Central   11536504   310

37             Oklahoma  OK         South    3751351   111

38               Oregon  OR          West    3831074    36

39         Pennsylvania  PA     Northeast   12702379   457

40         Rhode Island  RI     Northeast    1052567    16

41       South Carolina  SC         South    4625364   207

42         South Dakota  SD North Central     814180     8

43            Tennessee  TN         South    6346105   219

44                Texas  TX         South   25145561   805

45                 Utah  UT          West    2763885    22

46              Vermont  VT     Northeast     625741     2

47             Virginia  VA         South    8001024   250

48           Washington  WA          West    6724540    93

49        West Virginia  WV         South    1852994    27

50            Wisconsin  WI North Central    5686986    97

51              Wyoming  WY          West     563626     5

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Normalization
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