CSV READER

Hi,
This file contains real estate sales data. There are more than 230,000 rows. I am unable to open it with CSV Reader.
Message error is :
Execute failed: Row with ID ‘Row50000’ can’t be converted to the configured data types. Increasing the number of scanned rows or changing the target types might resolve the issue. Content of row: [id_mutation, date_mutation, numero_disposition, nature_mutation, valeur_fonciere, adresse_numero, adresse_suffixe, adresse_nom_voie, adresse_code_voie, code_postal, code_commune, nom_commune, code_departement, ancien_code_commune, ancien_nom_commune, id_parcelle, ancien_id_parcelle, numero_volume, lot1_numero, lot1_surface_carrez, lot2_numero, lot2_surface_carrez, lot3_numero, lot3_surface_carrez, lot4_numero, lot4_surface_carrez, lot5_numero, lot5_surface_carrez, nombre_lots, code_type_local, type_local, surface_reelle_bati, nombre_pieces_principales, code_nature_culture, nature_culture, code_nature_culture_speciale, nature_culture_speciale, surface_terrain, longitude, latitude, section_prefixe]

Why and what can i do ?
Thanks
BR

Difficult to say without the data. From memory I recall scenarios where in large files let’s say columns 1-10 hold the data and then there’s something in column 11 in one random row that is not part of what is scanned in preview.

Can you check whether row50000 has random data in a column that shouldn’t have data?

This is the way i use if you have time

I’m afraid I don’t have time but how about you check my recommendation? It may also be that some column is recognized as say integer and somehow in row 50000 there’s a special character, letter or something else in there.

The error is very specific to row50000 - why not check yourself quickly?

Also appreciate the screenshot. Pro tip though: paste the link if the source is available to online. That makes it easier for people to help you.

i find one problem
ROW 50002 (Excel) COLUMN HEADER
ROW 100002 (Excel) COLUMN HEADER
ROW 150002 (Excel) COLUMN HEADER
ROW 200002 (Excel) COLUMN HEADER

Is it the problem ?

Not sure I get what I’m looking at. Can you try and remove those rows manually to see if the data can be loaded after? That would validate they are causing the issue

“execute failed NO DATA” …

ok. I typed in the URL, downloaded the CSV, removed the rows you have shown from the CSV and it loads without issues:

Once you remove the rows, make sure you save and then close the file

I remove the 4 rows
I save as a new CSV and get >>>
Execute failed: The data row has too few data elements.

:interrobang: :interrobang: :interrobang:

Did you delete the content of the 4 rows or did you delete them entirely? Should be removed entirely.

Can you provide full error details?

2 Likes

@Brain in the past the R package readr was good at reading somewhat broken CSV files.

1 Like

I found the error :


i did not notice
Support short data rows !!!

Thanks for your help

3 Likes

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.