#Opopenen the file
f= open ('air-co.csv','r')
line = f.readline()
print(line)
2000,3.7
line = line.strip()
#to remove /n
line.split(',')
f.close()
with open ('air-co.csv' ,'r') as f:
for line in f:
print(f'>{line}')
>year,co_max_8hour_mean
>2000,3.7
>2001,4.2
>2002,2.7
>2003,3.2
>2004,2.8
>2005,2.4
>2006,2.6
>2007,1.7
>2008,1.6
>2009,1.9
>2010,2.4
>2011,2
>2012,1.9
>2013,5.5
>2014,1.8
>2015,3.3
>2016,2.2
>2017,1.7
>2018,2
i_count = 0
i_sum= 0
with open ('air-co.csv' ,'r') as f:
#ignore first line
f.readline()
for line in f:
i_count += 1
fields = line.strip().split(',')
i_sum += float(fields[-1])
f_avg = i_sum / i_count
print(f'Number of samples ; {i_count}')
print(f'Average:{f_avg:.3f}')
Number of samples ; 19
Average:2.611
#import pandas
import pandas as pd
#create data frame
df_medals = pd.read_csv('medals.csv')
#get the list of header/column name
df_medals.columns
# examine first 10 lines
df_medals.head(3)
df_medals.tail(3)
df_medals.describe()
df_medals.dtypes