df=pd.read_csv('.csv')
df.head()
df.info()
df.shape
df[''].unique()
df['']=df[''].str.strip('[2107]')
df['']=df[''].str.strip()
df['']=df[''].str.replace(',','').astype(int32)
df['']=pd.to_datetime(df[''])
df.to_csv('.csv')
df.reset_index('Rank',inplace=True)
df.reset_index(drop=True, inplace=True)
df.head(3)
df.index=df.index+1
df.head(3)
df['State'].value_counts()
df['State'].value_counts()[0:10].plot(kind='barh')
df[['State','Population']].groupby('State').sum().sort_values('Population'ascending=False)
df1=df[['State','Population']].pivot_table(index='State',aggfunc='sum').nlargest(10,columns='Population')
df1
df1.plot(kind='barh')