???? How to make a dataframe from a csv online file...that is zipped? | Pandas | Easy breezy Python!

У вашего броузера проблема в совместимости с HTML5

Do you need how data is behaving..but this data is on the Internet, and besides the files is compressed? With Python and Pandas it is very easy to visualize the data.
In this video you’ll see how straight forward it is to work with big data (Almost 3 million rows!) and plotting the results using conditions.
Here we’ll be working with the dataset from the cases of… (The microorganism that shan’t be named these days) to check how age plays an important role in mortality. No need to install anything on your computer, just click on this link, and you’ll be coding in Python in no time!
Thanks for watching us, don’t forget to leave your comments, we’ll be glad to hear from you!
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
???? Code in Python online with Google Colab (No need to install):
https://colab.research.google.com/
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
????️ Bits of code to copy and paste:
import pandas as pd
pd.__version__
!python—version

from zipfile import ZipFile
from io import BytesIO
from urllib.request import urlopen
url = urlopen(‘http://datosabiertos.salud.gob.mx/gobmx/salud/datos_abiertos/historicos/11/datos_abiertos_covid19_30.11.2020.zip’)
zipfile = ZipFile(BytesIO(url.read()))
df = pd.read_csv(zipfile.open(‘201130COVID19MEXICO.csv’),encoding = “ISO-8859-1”)

comorbidities=[‘DIABETES’, ‘EPOC’, ‘ASMA’, ‘INMUSUPR’, ‘HIPERTENSION’,‘CARDIOVASCULAR’, ‘OBESIDAD’, ‘RENAL_CRONICA’, ‘TABAQUISMO’,‘RESULTADO_LAB’]

dfh=dfage.query(‘RESULTADO_LAB == 1 & FECHA_DEF != “9999-99-99”’)
import plotly.express as px
fig = px.histogram(dfh, x=“EDAD”)
fig.show()

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
????Links mentioned in the video:
➡️ Data from the positive cases in Mexico
http://datosabiertos.salud.gob.mx/gobmx/salud/datos_abiertos/historicos/11/datos_abiertos_covid19_30.11.2020.zip
➡️ Vaccination documents:
US: https://www.cdc.gov/coronavirus/2019-ncov/vaccines/recommendations.html
UK: https://assets.publishing.service.gov.uk/government/uploads/system/uploads/attachment_data/file/961287/Greenbook_chapter_14a_v7_12Feb2021.pdf
MX: https://coronavirus.gob.mx/wp-content/uploads/2021/01/PolVx_COVID_-11Ene2021.pdf
???? Dictionaries related to the encoding information:
https://github.com/LilianaC/Pandas/blob/84f703db2200b65be6c7257e572d7b0b36b3d5b3/Catalogos_0412.xlsx
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
⏰ If you are in a hurry, here are the timestamps:
00:00 Introduction
02:05 Checking Pandas and Python version
02:50 Reading the data and creating the dataframe
04:10 Dataframe characteristics (len, shape, head, tail, columns)
08:10 Selecting dataframe columns (filter)
11:20 Working with cases labeled as positive (value_counts, plot.bar)
17:21 What about the age? (query, plotly express)
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
???? Our Other Channel in Spanish ????????:
https://youtube.com/cctmexico
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
???? Music
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
???? Hashtags:
#Pandas #Python