Trouble reading CSV file using pandas
I'm working on a data analysis project & I wanted to read data from CSV files using pandas. I read the first CSV file and It was fine but the second one gave me a UTF 8 encoding error. I exported the file to csv and encoded it to UTF-8 in the numbers spreadsheet app. However, the data frame is not in the expected format. Any idea why?
the original CSV file in numbers
Solution
it looks like your file is semicolon separated not comma separated.
To fix this you need to add the sep=';' parameter to pd.read_csv function.
pd.read_csv("mitb.csv", sep=';')
- Python upgrade and requirements compatibility
- What is the maximum length for an attribute name in python?
- Forward fill Numpy matrix / mask with values based on condition
- Databricks: Issue while creating spark data frame from pandas
- cookiecutter data science templet
- Docker health check always returning as unhealthy
- Issue solving differential equation with solve_ivp depending on t_span
- Pyinstaller loading splash screen
- How can I import pandas_datareader
- How to limit the maximum value of a numeric field in a Django model?
- Docker-compose can't import Django (ModuleNotFoundError)
- Asynchronous Requests with Python requests
- How to access submitted form request data in Django
- How can I find out the path of the Python that the py Launcher uses?
- How to get long file system path from python on Windows
- plt.plot meaning of [:,0] and [:,1]
- Using the http.HTTPStatus class in Python to return the meaning of a HTTP status code
- What type-hint contains both list and tuple?
- Sphinx, the best practices
- Artifacts with pygame when trying to update visible sprites only
- Convert numpy type to python
- Getting the Second Word in a Python 3 String
- How to iterate over columns of a pandas dataframe
- How can I add data to a geometry column in supabase using SQLalchemy?
- Poetry installed but `poetry: command not found`
- Why does scraping followers count from instagram fails?
- uwsgi with https getting socket option missing
- Pydroid - Unexpected EOF while reading a line
- Why am I getting only NaN values in all columns in Jupyter Notebook?
- Converting Nested Query string requests to a dictionary