awk -F ',' 'NF != x {print NR, $0} ' file.csv
where x is the number of columns 
-
-
-
open in Excel, cell B1: =countif(A1,",")

- Još 1 odgovor
Novi razgovor -
-
-
Drinking wine and writing pseudocode over here. All good, I like my career choice.
-
Definitely much better than writing code and drinking pseudowine :)
Kraj razgovora
Novi razgovor -
-
-
I recently had the same issue. I used csvclean: https://csvkit.readthedocs.io/en/1.0.2/scripts/csvclean.html …
- Još 1 odgovor
Novi razgovor -
-
-
Drinking some scotch while reading The Stranger on my deck. Not all of us work on Saturday evenings ;)
-
Good choice!
Kraj razgovora
Novi razgovor -
-
-
Split the file on newline and then count commas in each item in the list. Manually fix any list item with an outlier number of commas. Source: I deal with a lot of shitty data.
Hvala. Twitter će to iskoristiti za poboljšanje vaše vremenske crte. PoništiPoništi
-
-
-
In Pandas, that’s why you can just set error to False and keep warn true. Your file will be read, you will find the error line, and you wont use sh*t loads of RAM with low memory setting :)pic.twitter.com/r5dHpHokI3
Hvala. Twitter će to iskoristiti za poboljšanje vaše vremenske crte. PoništiPoništi
-
Čini se da učitavanje traje već neko vrijeme.
Twitter je možda preopterećen ili ima kratkotrajnih poteškoća u radu. Pokušajte ponovno ili potražite dodatne informacije u odjeljku Status Twittera.