you could also try;
data = pd.read_csv('file1.csv', on_bad_lines='skip')
Do note that this will cause the offending lines to be skipped.
Related Posts:
- Writing a pandas DataFrame to CSV file
- Writing a pandas DataFrame to CSV file
- Pandas: ValueError: cannot convert float NaN to integer
- How to load a tsv file into a Pandas DataFrame?
- OSError: Initializing from file failed on csv in Pandas
- python csv2libsvm.py: AttributeError: ‘_csv.reader’ object has no attribute ‘next’
- How to add pandas data to an existing csv file?
- How to parse tsv file with python?
- Error in Reading a csv file in pandas[CParserError: Error tokenizing data. C error: Buffer overflow caught – possible malformed input file.]
- how to sort pandas dataframe from one column
- TypeError: list indices must be integers or slices, not str
- Renaming column names in Pandas
- How to reset index in a pandas dataframe? [duplicate]
- how to reset index pandas dataframe after dropna() pandas dataframe
- Delete a column from a Pandas DataFrame
- IndexError: too many indices for array
- IndexError: too many indices for array
- How to deal with SettingWithCopyWarning in Pandas
- How to deal with SettingWithCopyWarning in Pandas
- Constructing pandas DataFrame from values in variables gives “ValueError: If using all scalar values, you must pass an index”
- How to iterate over rows in a DataFrame in Pandas
- pandas read_json: “If using all scalar values, you must pass an index”
- How to iterate over rows in a DataFrame in Pandas
- Reading an Excel file in python using pandas
- Selecting multiple columns in a Pandas dataframe
- Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
- Get statistics for each group (such as count, mean, etc) using pandas GroupBy?
- Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
- The difference between comparison to np.nan and isnull()
- Adding new column to existing DataFrame in Python pandas
- Modifing data while using iterrows() does not work
- ImportError: No module named pandas
- How to change the order of DataFrame columns?
- How to change the order of DataFrame columns?
- ImportError: No module named pandas. Pandas installed pip
- What does `ValueError: cannot reindex from a duplicate axis` mean?
- Pandas DataFrame Groupby two columns and get counts
- How can I use the apply() function for a single column?
- How to show all columns’ names on a large pandas dataframe?
- Convenient way to deal with ValueError: cannot reindex from a duplicate axis
- ValueError: Unknown label type: ‘continuous’
- How to groupby based on two columns in pandas?
- How to fix IndexError: invalid index to scalar variable
- “Series objects are mutable and cannot be hashed” error
- How to deal with SettingWithCopyWarning in Pandas
- Merging dataframes on index with pandas
- ImportError: No module named pandas
- IndexError: too many indices for array
- TypeError: ‘Series’ objects are mutable, thus they cannot be hashed problemwith column
- Create a Pandas Dataframe by appending one row at a time
- How to replace NaN values by Zeroes in a column of a Pandas Dataframe?
- ValueError: Length of values does not match length of index | Pandas DataFrame.unique()
- ValueError : I/O operation on closed file
- Convert Python dict into a dataframe
- re.sub erroring with “Expected string or bytes-like object”
- Creating an empty Pandas DataFrame, then filling it?
- How do I select rows from a DataFrame based on column values?
- How do I select rows from a DataFrame based on column values?
- DataFrame constructor not properly called! error
- Pandas group-by and sum
- How do I get the row count of a Pandas DataFrame?
- Python pandas groupby aggregate on multiple columns, then pivot
- Python Pandas Counting the Occurrences of a Specific value
- Convert pandas dataframe to NumPy array
- Count unique values per groups with Pandas
- DataFrame constructor not properly called
- Convert pandas Series to DataFrame
- Error:cannot convert float NaN to integer in pandas
- ImportError: Missing required dependencies [‘numpy’]
- Replacing column values in a pandas DataFrame
- Error”Can only compare identically-labeled Series objects” and sort_index
- How to iterate over rows in a DataFrame in Pandas
- Pandas group-by and sum
- How do I get the row count of a Pandas DataFrame?
- How can I one hot encode in Python?
- Python Pandas – Missing required dependencies [‘numpy’] 1
- Pandas “Can only compare identically-labeled DataFrame objects” error
- csv.Error: iterator should return strings, not bytes
- Get list from pandas dataframe column or row?
- pandas DataFrame “no numeric data to plot” error
- ValueError: Length of values does not match length of index | Pandas DataFrame.unique()
- ‘DataFrame’ object has no attribute ‘sort’
- ‘DataFrame’ object has no attribute ‘sort’
- pandas: merge (join) two data frames on multiple columns
- TypeError: cannot unpack non-iterable int objec
- Pandas DataFrame column to list
- Python Package bt: Bool index error
- Rename Pandas DataFrame Index
- Why do I get: “Length of values does not match length of index” error?
- pandas: filter rows of DataFrame with operator chaining
- why should I make a copy of a data frame in pandas
- ‘DataFrame’ object has no attribute ‘sort’
- Pandas, merging two dataframes on multiple columns, and multiplying result
- Convert DataFrame column type from string to datetime, dd/mm/yyyy format
- Python – Reading and writing csv files with utf-8 encoding
- Pandas how to use pd.cut()
- How to customize a scatter matrix to see all titles?
- How to Read .txt in Pandas
- Get a list from Pandas DataFrame column headers
- What is dtype(‘O’), in pandas?