Another software for Knowledge Analysts/ Knowledge Scientists with abilities in Python programming language.

Picture by way of Bret Kavanaugh on Unsplash
git clone https://github.com/ricklamers/gridstudio
cd gridstudio && ./run.sh
http://localhost:8080/
Picture by way of Webaroo on Unsplash

Load knowledge into the spreadsheet

# Learn all knowledge
df = pd.read_csv("https://opendata.ecdc.europa.eu/covid19/casedistribution/csv").dropna()
print(df.head())
# Convert date to integer (as a result of Grid Studio limitation)
df.dateRep = pd.to_datetime(df.dateRep, layout='%d/%m/%Y').dt.strftime('%Ypercentmpercentd').astype(int)

Change into knowledge

# Get Australia knowledge
df_oz = df[df.countriesAndTerritories == 'Australia']
# Retain most effective date, circumstances and deaths columns
df_oz = df_oz[['dateRep', 'cases', 'deaths']]
# Calculate cumulative circumstances & deaths
df_oz = df_oz.sort_values('dateRep')
df_oz['cumCases'] = df_oz.circumstances.cumsum()
df_oz['cumDeaths'] = df_oz.deaths.cumsum()

Render the knowledge into the spreadsheet

# Display in sheet
sheet("A1", df_oz)

Extra options within the spreadsheet

knowledge = sheet("B1:B106")
knowledge.plot()
display()
knowledge = sheet("B1:B106")
knowledge.plot(identify='Day-to-day New Instances')
display()
Picture by way of Sangga Rima Roman Selia on Unsplash

Source link

LEAVE A REPLY

Please enter your comment!
Please enter your name here