Python and Pandas to look for data in the web

Some data searchings made with Python and Pandas, a practical case, to look for data in a particular row, based on a value searched in a column and then getting another value, in another column of that row, like when you need to know for a city a particular number referring to something that you are looking for, like number of inhabitats of the city, in a list of cities, etc.

Below, you can find code and live coding video about this topic: serching data on the web.

import pandas as pd
import requests

def days(day, month, year, pr):
    where = "https://raw.githubusercontent.com/pcm-dpc/COVID-19/master/dati-province/dpc-covid19-ita-province-{}{}{}.csv".format(year, month, day)
    url = requests.get(where)
    with open("data2.csv", "w", encoding="utf-8") as file:
        file.write(url.text)
    df = pd.read_csv("data2.csv", error_bad_lines=False)
    mydata = df.loc[df["denominazione_provincia"]==pr]["totale_casi"]
    mytime = df.loc[df["denominazione_provincia"]==pr]["data"]
    print(list(mytime)[0].split()[0], end="\t")
    print(list(mydata)[0])


def province(pr):
    for n in range(1, 15):
        if n < 10:
            days("0" + str(n), "03", "2020", pr)
        else:
            days(str(n), "03", "2020", pr)


province("Milano")


Subscribe to the newsletter for updates
Tkinter templates
Avatar My youtube channel

Twitter: @pythonprogrammi - python_pygame

Videos

Speech recognition game

Pygame's Platform Game

Other Pygame's posts

Published by pythonprogramming

Started with basic on the spectrum, loved javascript in the 90ies and python in the 2000, now I am back with python, still making some javascript stuff when needed.