.Show a number of primary and secondary cities (Province column only). The expected output is Province Туре Primary 10 Secondary

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
100%

Using Python (jupyter notebook) anaconda

I have already the import csv file for this code

54.Show a number of primary and secondary cities (Province column only).
The expected output is
Province
Туре
Primary
10
Secondary
7
Transcribed Image Text:54.Show a number of primary and secondary cities (Province column only). The expected output is Province Туре Primary 10 Secondary 7
In [119]: #Ex-54
province[province.Type
#province[province.Type
'Primary'][['Primary','Province']].count ()
'Secondary'][['Province']].count()
==
KeyError
Traceback (most recent call las
t)
<ipython-input-119-326bffdd2cc4> in <module>
1 #Ex-54
----> 2 province[province.Type
'Primary'][['Primary','Province']].coun
t()
3 #province[province.Type
'Secondary'][['Province']].count()
==
/opt/anaconda3/lib/python3.8/site-packages/pandas/core/frame.py
in
_geti
tem
(self, key)
2906
if is iterator(key):
= list(key)
self.loc._get_listlike_indexer (key, axis=1,
2907
key
-> 2908
indexer
raise_missing=True)[1]
2909
2910
# take () does not accept boolean indexers
/opt/anaconda3/lib/python3.8/site-packages/pandas/core/indexing.py in
_ge
t_listlike_indexer(self, key, axis, raise_missing)
1252
keyarr, indexer, new_indexer
ax._reindex_non_unique
%3D
(keyarr)
1253
-> 1254
self._validate_read_indexer (keyarr, indexer, axis,
Transcribed Image Text:In [119]: #Ex-54 province[province.Type #province[province.Type 'Primary'][['Primary','Province']].count () 'Secondary'][['Province']].count() == KeyError Traceback (most recent call las t) <ipython-input-119-326bffdd2cc4> in <module> 1 #Ex-54 ----> 2 province[province.Type 'Primary'][['Primary','Province']].coun t() 3 #province[province.Type 'Secondary'][['Province']].count() == /opt/anaconda3/lib/python3.8/site-packages/pandas/core/frame.py in _geti tem (self, key) 2906 if is iterator(key): = list(key) self.loc._get_listlike_indexer (key, axis=1, 2907 key -> 2908 indexer raise_missing=True)[1] 2909 2910 # take () does not accept boolean indexers /opt/anaconda3/lib/python3.8/site-packages/pandas/core/indexing.py in _ge t_listlike_indexer(self, key, axis, raise_missing) 1252 keyarr, indexer, new_indexer ax._reindex_non_unique %3D (keyarr) 1253 -> 1254 self._validate_read_indexer (keyarr, indexer, axis,
Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY