mport pandas as pd import matplotlib.pyplot as plt dengue = pd.read_excel('Dengue.xlsx', header=0, index_col='Date', parse_dates=True, squeeze=True) reg = dengue['Total'] reg = reg.reset_index() reg.hist(bins = 100) plt.grid(False)

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
import pandas as pd
import matplotlib.pyplot as plt

dengue = pd.read_excel('Dengue.xlsx', header=0, index_col='Date', parse_dates=True, squeeze=True)
reg = dengue['Total']
reg = reg.reset_index()
reg.hist(bins = 100)
plt.grid(False)
plt.show()
 
 
import pandas as pd
import matplotlib.pyplot as plt
dengue = pd.read_excel('Dengue.xlsx', header=0, index_col='Date' parse dates=True, squeeze=True)
dengue['Total']
reg =
reg = reg.reset_index()
reg.hist(bins = 100)
plt.grid(False)
plt.show()
FileNotFoundError
Traceback (most recent call last)
<ipython-input-6-453415c79af5> in <module>()
2 import matplotlib.pyplot as plt
3
----> 4 dengue = pd.read_excel('Dengue.xlsx', header=0, index_col='Date', parse_dates=True, squeeze=True)
%3D
5 reg = dengue['Total']
6 reg = reg.reset_index()
6 frames
ex in open_workbook (filename, logfile, verbosity, use_mmap, file_contents, encoding_override,
/usr/local/lib/python3.7/dist-packages/xlrd/ init
formatting_info, on_demand, ragged_rows)
peek = file_contents[:peeksz]
114
115
else:
--> 116
with open(filename, "rb") as f:
peek = f.read(peeksz)
if peek == b"PK\xe3\x04": # a ZIP file
117
118
FileNotFoundError: [Errno 2] No such file or directory: 'Dengue.xlsx'
Transcribed Image Text:import pandas as pd import matplotlib.pyplot as plt dengue = pd.read_excel('Dengue.xlsx', header=0, index_col='Date' parse dates=True, squeeze=True) dengue['Total'] reg = reg = reg.reset_index() reg.hist(bins = 100) plt.grid(False) plt.show() FileNotFoundError Traceback (most recent call last) <ipython-input-6-453415c79af5> in <module>() 2 import matplotlib.pyplot as plt 3 ----> 4 dengue = pd.read_excel('Dengue.xlsx', header=0, index_col='Date', parse_dates=True, squeeze=True) %3D 5 reg = dengue['Total'] 6 reg = reg.reset_index() 6 frames ex in open_workbook (filename, logfile, verbosity, use_mmap, file_contents, encoding_override, /usr/local/lib/python3.7/dist-packages/xlrd/ init formatting_info, on_demand, ragged_rows) peek = file_contents[:peeksz] 114 115 else: --> 116 with open(filename, "rb") as f: peek = f.read(peeksz) if peek == b"PK\xe3\x04": # a ZIP file 117 118 FileNotFoundError: [Errno 2] No such file or directory: 'Dengue.xlsx'
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Files and Directory
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
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