ValueError: not enough values to unpack (expected 11, got 1)

by

For the line

line.split()

What are you splitting on? Looks like a CSV, so try

line.split(',')

Example:

"one,two,three".split()  # returns one element ["one,two,three"]
"one,two,three".split(',')  # returns three elements ["one", "two", "three"]

As @TigerhawkT3 mentions, it would be better to use the CSV module. Incredibly quick and easy method available here.

More Related Contents:

  1. A simple maths operation on a CSV column using python [closed]
  2. How to write a python code which copies a unique column from an output file to a .csv file
  3. How can I convert JSON to CSV?
  4. Skip the headers when editing a csv file using Python
  5. How to add a new column to a CSV file?
  6. Skip rows during csv import pandas
  7. Python CSV error: line contains NULL byte
  8. What is the fastest way to upload a big csv file in notebook to work with python pandas?
  9. sort csv by column
  10. Compare two CSV files and search for similar items
  11. Pandas read csv file with float values results in weird rounding and decimal digits
  12. Why does csvwriter.writerow() put a comma after each character?
  13. Key error when selecting columns in pandas dataframe after read_csv
  14. How to delete columns in a CSV file?
  15. Precision lost while using read_csv in pandas
  16. Python Pandas: How to read only first n rows of CSV files in?
  17. Modify an existing Excel file using Openpyxl in Python
  18. read and write on same csv file
  19. Pythonically add header to a csv file
  20. Pandas – write Multiindex rows with to_csv
  21. How can I merge 200 CSV files in Python?
  22. UnicodeDecodeError: ‘utf-8’ codec can’t decode byte 0x8b in position 1: invalid start byte, while reading csv file in pandas
  23. How can I use io.StringIO() with the csv module?
  24. How to Pretty Print a CSV file in Python
  25. how to skip blank line while reading CSV file using python
  26. pandas read csv with extra commas in column
  27. how to specify the datetime format in read_csv
  28. Convert nested JSON to CSV file in Python
  29. How to return a csv file/Pandas DataFrame in JSON format using FastAPI?
  30. Python: Writing Nested Dictionary to CSV

Leave a Comment