Learn practical skills, build real-world projects, and advance your career

Pedestrians in inner cities during the Corona crisis

Author: Andreas Traut

On Saturday 21.03.2020 exit locks had been implemented in order to protect the people from the Corona virus. I read an article about the company Hystreet (https://hystreet.com), who provides statistics about pedestrians in inner cities. Due to the implemented exit lock the number should decrease from 21.03.2020 onwards. Hystreet offers free downloadable csv files for private use. In this example I wanted to see these descresing numbers. So let's start:

First I downloaded the csv Files for Ulm, Münsterplatz for several weeks (that's why I received one csv file for each week). Then I used Pandas "read_csv":

import pandas as pd
from matplotlib import pyplot, dates
import seaborn as sns
from matplotlib.ticker import FuncFormatter
import glob

#%% read all files
all_files = glob.glob("*.csv")
li = []
for filename in all_files:
    df = pd.read_csv(filename, index_col=None, header=0, sep=';')

df = pd.concat(li, axis=0, ignore_index=True)

Now let's have a look at the data types: