import pandas as pd df = pd.read_csv(<path_to_csv_file>) new_row = pd.DataFrame({'Name':'Geeks', 'Team':'Boston', 'Number':3, 'Position':'PG', 'Age':33, 'Height':'6-2', 'Weight':189, 'College':'MIT', 'Salary':99999}, index =[0]) df = pd.concat([new_row, df.ix[:]]).reset_index(drop = True)