Using python, I would like to create 2 columns from 'U.S custom ports'.
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
Related questions
Question
please answer within 30 minutes.
Transcribed Image Text:Using python, I would like to create 2 columns from
'U.S custom ports.
The two columns: 1. is for city, 2 is for the state.
Thanks!
A
B
с
D
E
F
G
H
1 U.S. Custom Ports
Coast
ImportTons ExportTons
A
2000
19
9165
39 Gloucester City, NJ
40
41 Gramercy, LA
G
2000
1.54
935.26
42
43 Gulfport, MS
G
2000
81495.34
74171.2
44
45 Honolulu, HI
HI
2000 13078.36
13331.02
46
47 Houston, TX
G
2000 366821.43 366313.05
48
49 Jacksonville, FL
A
2000 30913.86
79556.84
50
51 Kodiak, AK
AK
2000
0
0
52
53 Lake Charles, LA
G
2000
0
185.48
54
P
2000 2401299.7
802255.11
55 Long Beach, CA
56
P
2000
0
9.6
57 Longview, WA
58
P
2000 2428793.69
798948.97
59 Los Angeles, CA
60
61 Mayaguez, PR
PR
2000
9737.62 10388.77
62
63 Miami, FL
A
2000
335294 348209.69
64
65 Mobile, AL
G
2000
5513.86
8638.09
66
67 New Orleans, LA
G
2000 91384.38 138056.23
68
69 New York, NY
A
2000 1511578.59
688764.87
70
71 Newport News, VA
A
2000 40057.13
33729.77
72
73 Norfolk, VA
A
2000 437522.5
412877.64
74
75 Oakland, CA
P
2000 418923.68
569849.4
76
77 Panama City, FL
G
2000
7
8
78
79 Pensacola, FL
G
2000
0
0
80
Year
I
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 9 images
Knowledge Booster
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.Recommended textbooks for you
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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education