Read CSV - Selecting the Row that Contains Column Header


To select which row to use as a header when reading a csv into a Pandas dataframe, use the "header" parameter to pass the row index of the row that contains the headers.

In the example below, we are using the values in the 3rd row for the headers of the dataframe.

 1|  import pandas as pd
 3|  df = pd.read_csv('sales.csv', header=2)
Did you find this snippet useful?

Sign up for free to to add this to your code library