import pandas as pd
from io import StringIO
data = StringIO('''\
Date,Confirmed,Deaths
2/29/2020,2,0
3/1/2020,3,0
3/2/2020,4,0
3/3/2020,4,0
3/4/2020,4,0
3/5/2020,5,0
3/6/2020,5,0
3/7/2020,6,0
3/8/2020,7,0
3/9/2020,7,0''')
df = pd.read_csv(data, sep=',')
df
Date | Confirmed | Deaths | |
---|---|---|---|
0 | 2/29/2020 | 2 | 0 |
1 | 3/1/2020 | 3 | 0 |
2 | 3/2/2020 | 4 | 0 |
3 | 3/3/2020 | 4 | 0 |
4 | 3/4/2020 | 4 | 0 |
5 | 3/5/2020 | 5 | 0 |
6 | 3/6/2020 | 5 | 0 |
7 | 3/7/2020 | 6 | 0 |
8 | 3/8/2020 | 7 | 0 |
9 | 3/9/2020 | 7 | 0 |
New_Cases = [i for i in range(10)]
df['New_Cases'] = New_Cases
df
Date | Confirmed | Deaths | New_Cases | |
---|---|---|---|---|
0 | 2/29/2020 | 2 | 0 | 0 |
1 | 3/1/2020 | 3 | 0 | 1 |
2 | 3/2/2020 | 4 | 0 | 2 |
3 | 3/3/2020 | 4 | 0 | 3 |
4 | 3/4/2020 | 4 | 0 | 4 |
5 | 3/5/2020 | 5 | 0 | 5 |
6 | 3/6/2020 | 5 | 0 | 6 |
7 | 3/7/2020 | 6 | 0 | 7 |
8 | 3/8/2020 | 7 | 0 | 8 |
9 | 3/9/2020 | 7 | 0 | 9 |
print(df.to_csv(index=False))
Date,Confirmed,Deaths,New_Cases 2/29/2020,2,0,0 3/1/2020,3,0,1 3/2/2020,4,0,2 3/3/2020,4,0,3 3/4/2020,4,0,4 3/5/2020,5,0,5 3/6/2020,5,0,6 3/7/2020,6,0,7 3/8/2020,7,0,8 3/9/2020,7,0,9