Read a csv file in unknown encoding format
I am trying to read a CSV file in python(google colab). Please, find attached the file in the following link: https://github.com/LeGentilHomme/CSV-FILE/blob/4b69985482e59906b64a540b9c0d0a7fce31a37e/exportIndicateurs(7).csv In fact, this time series data in French contains semi-columns and the variables are contained in the rows, while the time or dates are in the columns. After multiple trials, what I get is a table with all the values and semi-columns in one column, and the rest of the cells shows NaN values. I have tried the following code:
df=pd.read_csv("exportIndicateurs(7).csv", delimiter=';',header=1, encoding='latin-1')
df
but I get the results that I have attached in the following pictures.
Thank you in advance for your help.Result picture
Solution
Use (-*;) as a regex separator in read_csv :
gh_link = "https://raw.githubusercontent.com/LeGentilHomme/CSV-FILE/4b69985482e59906b64a540b9c0d0a7fce31a37e/exportIndicateurs(7).csv"
df = pd.read_csv(gh_link, sep="-*;", header=2, engine="python")
Output:
- Python: get the names of specific file types in a given folder
- readr has no reasons to say there are less columns than expected
- Write CSV file with double quotes for particular column not working
- How to pretty-print / view tabular file (e.g., CSV) from the command line?
- How can I read a csv file and pass the values to a List<String> in flutter?
- "extra data after last expected column" while trying to import a csv file into postgresql
- Count the number of rows for each csv, faster code
- Among many subfolders, find CSVs starting with a given string and within ZIPs or not, and merge them while adding their names in a new column with R
- How to get rid of "Unnamed: 0" column in a pandas DataFrame read in from CSV file?
- Dowload public Google Spreadsheet
- Retrieving repeated records from a CSV using the Java Stream API
- How to convert array of ActiveRecord models to CSV?
- How to properly escape a double quote in CSV?
- How to get affected row count on WordPress query?
- How can I clean a year column with messy values?
- How can I extract specific values from a .csv-File and add them into a specific cell in a pre-exisiting dataframe/tibble in R automatically?
- add data to specific row and colum in csv python
- How can I output MySQL query results in CSV format?
- How to save values to a CSV file in exponent in python
- Parsing csv file to NSMutableArray
- Is there a way to read CSV in node.js synchronously?
- Python FastAPI: How to return a Response with Unicode or non-ASCII characters encoded into JSON or CSV data?
- Zip list of files python
- What's the most robust way to efficiently parse CSV using awk?
- Having an issue displaying a part of a string read in from a csv file
- How to scrape a csv table contained within a JavaScript button using Python?
- How to join two large CSV files?
- efficient way to join 65,000 .csv files
- Merging multiple csv files in java
- join two csv files with key value