👋 Hello! I'm Alphonsio the robot. Ask me a question, I'll try to answer.
How to import a csv file in a Pandas Dataframe in Python?
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