Skip to content

Instantly share code, notes, and snippets.

View nikdudaev's full-sized avatar

Nikolay Dudaev nikdudaev

View GitHub Profile
import pandas as pd
import argparse
def excel_to_csv(excel_file, output_csv):
# Load the Excel file
xls = pd.ExcelFile(excel_file)
# Read all sheets into a list of DataFrames
df_list = [xls.parse(sheet_name) for sheet_name in xls.sheet_names]
@nikdudaev
nikdudaev / covid_data_deaths_cases.R
Last active May 18, 2020 19:16
Our World in Data data transformation for this notebook https://observablehq.com/@nd/recreating-covid-19-cases-chart
library(readr)
library(dplyr)
library(tidyr)
library(caTools)
options(scipen = 999999)
df <- read_csv("~/Downloads/owid-covid-data.csv")
countries_to_use <- c(
"Austria",