Skip to content

Instantly share code, notes, and snippets.

@snippsat

snippsat/gist:7a070b830b6f106f4c21639edf0e7bed

Created April 15, 2020 20:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save snippsat/7a070b830b6f106f4c21639edf0e7bed to your computer and use it in GitHub Desktop.
Save snippsat/7a070b830b6f106f4c21639edf0e7bed to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
{
"cells": [
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Date</th>\n",
" <th>Confirmed</th>\n",
" <th>Deaths</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2/29/2020</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>3/1/2020</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>3/2/2020</td>\n",
" <td>4</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>3/3/2020</td>\n",
" <td>4</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>3/4/2020</td>\n",
" <td>4</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>3/5/2020</td>\n",
" <td>5</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>3/6/2020</td>\n",
" <td>5</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>3/7/2020</td>\n",
" <td>6</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>3/8/2020</td>\n",
" <td>7</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>3/9/2020</td>\n",
" <td>7</td>\n",
" <td>0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" Date Confirmed Deaths\n",
"0 2/29/2020 2 0\n",
"1 3/1/2020 3 0\n",
"2 3/2/2020 4 0\n",
"3 3/3/2020 4 0\n",
"4 3/4/2020 4 0\n",
"5 3/5/2020 5 0\n",
"6 3/6/2020 5 0\n",
"7 3/7/2020 6 0\n",
"8 3/8/2020 7 0\n",
"9 3/9/2020 7 0"
]
},
"execution_count": 2,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"import pandas as pd\n",
"from io import StringIO\n",
"\n",
"data = StringIO('''\\\n",
"Date,Confirmed,Deaths\n",
"2/29/2020,2,0\n",
"3/1/2020,3,0\n",
"3/2/2020,4,0\n",
"3/3/2020,4,0\n",
"3/4/2020,4,0\n",
"3/5/2020,5,0\n",
"3/6/2020,5,0\n",
"3/7/2020,6,0\n",
"3/8/2020,7,0\n",
"3/9/2020,7,0''')\n",
"\n",
"df = pd.read_csv(data, sep=',')\n",
"df"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [],
"source": [
"New_Cases = [i for i in range(10)]"
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {},
"outputs": [],
"source": [
"df['New_Cases'] = New_Cases"
]
},
{
"cell_type": "code",
"execution_count": 8,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Date</th>\n",
" <th>Confirmed</th>\n",
" <th>Deaths</th>\n",
" <th>New_Cases</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2/29/2020</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>3/1/2020</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>3/2/2020</td>\n",
" <td>4</td>\n",
" <td>0</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>3/3/2020</td>\n",
" <td>4</td>\n",
" <td>0</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>3/4/2020</td>\n",
" <td>4</td>\n",
" <td>0</td>\n",
" <td>4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>3/5/2020</td>\n",
" <td>5</td>\n",
" <td>0</td>\n",
" <td>5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>3/6/2020</td>\n",
" <td>5</td>\n",
" <td>0</td>\n",
" <td>6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>3/7/2020</td>\n",
" <td>6</td>\n",
" <td>0</td>\n",
" <td>7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>3/8/2020</td>\n",
" <td>7</td>\n",
" <td>0</td>\n",
" <td>8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>3/9/2020</td>\n",
" <td>7</td>\n",
" <td>0</td>\n",
" <td>9</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" Date Confirmed Deaths New_Cases\n",
"0 2/29/2020 2 0 0\n",
"1 3/1/2020 3 0 1\n",
"2 3/2/2020 4 0 2\n",
"3 3/3/2020 4 0 3\n",
"4 3/4/2020 4 0 4\n",
"5 3/5/2020 5 0 5\n",
"6 3/6/2020 5 0 6\n",
"7 3/7/2020 6 0 7\n",
"8 3/8/2020 7 0 8\n",
"9 3/9/2020 7 0 9"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Date,Confirmed,Deaths,New_Cases\n",
"2/29/2020,2,0,0\n",
"3/1/2020,3,0,1\n",
"3/2/2020,4,0,2\n",
"3/3/2020,4,0,3\n",
"3/4/2020,4,0,4\n",
"3/5/2020,5,0,5\n",
"3/6/2020,5,0,6\n",
"3/7/2020,6,0,7\n",
"3/8/2020,7,0,8\n",
"3/9/2020,7,0,9\n",
"\n"
]
}
],
"source": [
"print(df.to_csv(index=False))"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.7.3"
}
},
"nbformat": 4,
"nbformat_minor": 4
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment