import pandas as pd ipl_matches_df = pd.read_csv('matches.csv') Index(['id', 'season', 'city', 'date', 'team1', 'team2', 'toss_winner', 'toss_decision', 'result', 'dl_applied', 'winner', 'win_by_runs', 'win_by_wickets', 'player_of_match', 'venue', 'umpire1', 'umpire2', 'umpire3'], dtype='object') for col in ipl_matches_df: print(ipl_matches_df[col].unique()) ipl_matches_df.umpire3.first_valid_index()ipl_matches_df.loc[633:640] import seaborn as sns import matplotlib import matplotlib.pyplot as plt %matplotlib inline sns.color_palette("Paired") matplotlib.rcParams['font.size'] = 14 matplotlib.rcParams['figure.figsize'] = (12, 8) matplotlib.rcParams['figure.facecolor'] = '#00000000' venue_df = pd.DataFrame(columns=['venue', 'matches']) for items in venue_ser.iteritems(): temp_df = pd.DataFrame({ 'venue':[items[0]], 'matches':[items[1]] }) venue_df = venue_df.append(temp_df, ignore_index=True)