In Python, how to create a dataframe from a csv file?

In Python, the best way to import a csv file in a Pandas Dataframe is to use the pandas.read_csv() method. Here is an example:

import pandas as pd
df = pd.read_csv("filename.csv") 

The read_csv() function accepts optional parameters. The following example loads a csv file and specifies the separator:

df = pd.read_csv("filename.csv", sep=';') 

The header=None specifies the csv file does not contain header:

df = pd.read_csv("filename.csv", header=None) 

A list of all the options is detailed on this page: https://pandas.pydata.org/docs/reference/api/pandas.read_csv.html