I have a question about pandas. I am trying to open the raw_fighter_details.csv file on this kaggle page: https://www.kaggle.com/datasets/rajeevw/ufcdata?select=raw_fighter_details.csv via pandas in Jupyter Notebook.
This is the code I'm using:
import pandas as pd
df = pd.read_csv("C:/Users/jimwe_/OneDrive/Bureaublad/raw_fighter_details.csv")
df.head()
It is not opening correctly. All the seperate columns have been made such as: fighter_name, Height and Weight but it is putting all the data in the rows below into the fighter_name column.
It is however correctly opening another csv file. The one on this kaggle page: https://www.kaggle.com/datasets/harlfoxem/housesalesprediction
Does anyone know why the first file is not opening correctly and if so do you have a solution?
