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:
- Merge two CSV files based on a data from the first column
- python store new value
- Convert CSV to JSON using PHP
- Import attributes using CSV with woocommerce
- Can the Spark warning "CSV header does not conform to the schema" be changed to a fault, through the configuration, and stop the current operation?
- Create CSV from specific columns in another CSV using shell scripting
- extract strings between square brackets and arrange them as csv
- Read in CSV in Pyspark with correct Datatypes
- R: Read csv with row and column name
- Adding the header to a csv file
- Machine Learning python code for reading file
- How to process multiple csv with pyspark in aws glue?
- How to generate a CSV file with jinja2 template with dict elements in Ansible?
- Athena unable to parse date using OpenCSVSerde
- Convert from Database / Excel / CSV to YAML data fixtures?
- CSV to JSON using python, only selected columns, and creating new entry for each cell having multiple values from a single CSV cell?
- How to pretty-print / view tabular file (e.g., CSV) from the command line?
- Powershell - Create new user accounts from CSV & simultaneously populate these new accounts with template account info (Address & group membership)
- UnicodeDecodeError: 'utf-8' codec can't decode byte 0x8b in position 1: invalid start byte, while reading csv file in pandas
- Python pandas to_csv causes OSError: [Errno 22] Invalid argument
- jitbit/CsvExport in Blazor inserts »¿ to the first row, first column of file
- AWK or alternative way to join (and occasionally correct) two fields in csv
- Creating CSV string without plugin
- Replace Words in File Names Based on Imported CSV
- How to export Django model data into CSV file
- remove the first character of each .txt file with Powershell
- What's the easiest way to Import a CSV file into a Django Model?
- Deleting a row from a CSV based on line number and shifting all lines afterwards
- unterminated CSV quoted field in Postgres
- How to compile a python script into executable program and can be use by others