Python Forum
pandas.errors.ParserError: Error tokenizing data. C error: Expected 9 fields in line
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
pandas.errors.ParserError: Error tokenizing data. C error: Expected 9 fields in line
#1
Using Pandas to manipulate CSV file which return me this error
Quote:


X = pd.read_csv(r"D:\Clustering\text-cluster-master\text-cluster-master\Articles.csv", index_col='id')
X.head()
Debugging errors
<frame not available>
read, parsers.py:2056
read, parsers.py:1052
_read, parsers.py:463
read_csv, parsers.py:605
<module>, similarity.py:58

Running time error
Error:
D:\Python3.8.0\Python\python.exe D:/Clustering/text-cluster-master/similarity.py Traceback (most recent call last): File "D:/Clustering/text-cluster-master/similarity.py", line 58, in <module> X = pd.read_csv(r"D:\Clustering\text-cluster-master\text-cluster-master\Articles.csv", index_col='id') File "D:\Python3.8.0\Python\lib\site-packages\pandas\io\parsers.py", line 605, in read_csv return _read(filepath_or_buffer, kwds) File "D:\Python3.8.0\Python\lib\site-packages\pandas\io\parsers.py", line 463, in _read return parser.read(nrows) File "D:\Python3.8.0\Python\lib\site-packages\pandas\io\parsers.py", line 1052, in read index, columns, col_dict = self._engine.read(nrows) File "D:\Python3.8.0\Python\lib\site-packages\pandas\io\parsers.py", line 2056, in read data = self._reader.read(nrows) File "pandas\_libs\parsers.pyx", line 756, in pandas._libs.parsers.TextReader.read File "pandas\_libs\parsers.pyx", line 771, in pandas._libs.parsers.TextReader._read_low_memory File "pandas\_libs\parsers.pyx", line 827, in pandas._libs.parsers.TextReader._read_rows File "pandas\_libs\parsers.pyx", line 814, in pandas._libs.parsers.TextReader._tokenize_rows File "pandas\_libs\parsers.pyx", line 1951, in pandas._libs.parsers.raise_parser_error pandas.errors.ParserError: Error tokenizing data. C error: Expected 9 fields in line 4, saw 10
Reply
#2
(Jun-13-2021, 07:42 AM)Anldra12 Wrote:
Error:
pandas.errors.ParserError: Error tokenizing data. C error: Expected 9 fields in line 4, saw 10
Look at line 4 of your *.CSV file. I think there is a field separator (a comma I presume) in an unquoted text field.
Reply
#3
@ibreeden at line 4 i have only pandas library see this ---> import matplotlib
Reply
#4
1. Try defining the particular character used in dataset to separate fields eg -

X = pd.read_csv(r"D:\Clustering\text-cluster-master\text-cluster-master\Articles.csv", index_col='id',delimiter='|')
2. Also you may skip any erroneous row if that helps
X = pd.read_csv(r"D:\Clustering\text-cluster-master\text-cluster-master\Articles.csv", index_col='id', , error_bad_lines=False)
Reply
#5
(Jun-13-2021, 03:16 PM)Anldra12 Wrote: at line 4 i have only pandas library see this ---> import matplotlib
No. I said line 4 of the CSV file. Your CSV file is "D:\Clustering\text-cluster-master\text-cluster-master\Articles.csv"
Reply
#6
@klllmmm but after apply bad lines = false it return me key error because search related errors

error_bad_lines=False 
X = pd.read_csv(r"D:\Clustering\text-cluster-master\text-cluster-master\Articles.csv", index_col='id', , error_bad_lines=False)
after apply above lines4 its return me this errors
Quote:

Error:
D:\Python3.8.0\Python\python.exe D:/Clustering/text-cluster-master/similarity.py b'Skipping line 4: expected 9 fields, saw 10\nSkipping line 5: expected 9 fields, saw 10\nSkipping line 6: expected 9 fields, saw 14\nSkipping line 7: expected 9 fields, saw 16\nSkipping line 8: expected 9 fields, saw 11\nSkipping line 9: expected 9 fields, saw 20\nSkipping line 10: expected 9 fields, saw 11\nSkipping line 11: expected 9 fields, saw 11\nSkipping line 14: expected 9 fields, saw 10\nSkipping line 15: expected 9 fields, saw 11\nSkipping line 17: expected 9 fields, saw 10\nSkipping line 18: expected 9 fields, saw 10\nSkipping line 21: expected 9 fields, saw 11\nSkipping line 24: expected 9 fields, saw 16\nSkipping line 25: expected 9 fields, saw 12\nSkipping line 26: expected 9 fields, saw 14\nSkipping line 27: expected 9 fields, saw 15\nSkipping line 28: expected 9 fields, saw 10\nSkipping line 30: expected 9 fields, saw 14\nSkipping line 31: expected 9 fields, saw 10\nSkipping line 32: expected 9 fields, saw 16\nSkipping line 33: expected 9 fields, saw 10\nSkipping line 36: expected 9 fields, saw 11\nSkipping line 39: expected 9 fields, saw 10\nSkipping line 40: expected 9 fields, saw 45\nSkipping line 41: expected 9 fields, saw 13\nSkipping line 43: expected 9 fields, saw 11\nSkipping line 49: expected 9 fields, saw 17\nSkipping line 51: expected 9 fields, saw 11\nSkipping line 52: expected 9 fields, saw 17\nSkipping line 55: expected 9 fields, saw 10\nSkipping line 56: expected 9 fields, saw 16\nSkipping line 57: expected 9 fields, saw 10\nSkipping line 58: expected 9 fields, saw 11\nSkipping line 59: expected 9 fields, saw 16\nSkipping line 62: expected 9 fields, saw 17\nSkipping line 64: expected 9 fields, saw 26\nSkipping line 65: expected 9 fields, saw 11\nSkipping line 66: expected 9 fields, saw 11\nSkipping line 67: expected 9 fields, saw 13\nSkipping line 68: expected 9 fields, saw 14\nSkipping line 73: expected 9 fields, saw 18\nSkipping line 74: expected 9 fields, saw 11\nSkipping line 75: expected 9 fields, saw 16\nSkipping line 76: expected 9 fields, saw 13\nSkipping line 77: expected 9 fields, saw 12\nSkipping line 79: expected 9 fields, saw 11\nSkipping line 80: expected 9 fields, saw 10\nSkipping line 81: expected 9 fields, saw 20\nSkipping line 82: expected 9 fields, saw 16\nSkipping line 84: expected 9 fields, saw 10\nSkipping line 85: expected 9 fields, saw 10\nSkipping line 87: expected 9 fields, saw 12\nSkipping line 88: expected 9 fields, saw 10\nSkipping line 89: expected 9 fields, saw 22\nSkipping line 90: expected 9 fields, saw 11\nSkipping line 91: expected 9 fields, saw 10\nSkipping line 92: expected 9 fields, saw 13\nSkipping line 93: expected 9 fields, saw 11\nSkipping line 94: expected 9 fields, saw 12\nSkipping line 95: expected 9 fields, saw 19\nSkipping line 96: expected 9 fields, saw 16\nSkipping line 97: expected 9 fields, saw 24\nSkipping line 98: expected 9 fields, saw 19\nSkipping line 99: expected 9 fields, saw 13\nSkipping line 100: expected 9 fields, saw 20\nSkipping line 102: expected 9 fields, saw 22\nSkipping line 103: expected 9 fields, saw 25\nSkipping line 109: expected 9 fields, saw 12\nSkipping line 112: expected 9 fields, saw 15\nSkipping line 113: expected 9 fields, saw 16\nSkipping line 114: expected 9 fields, saw 11\nSkipping line 117: expected 9 fields, saw 10\nSkipping line 118: expected 9 fields, saw 12\nSkipping line 119: expected 9 fields, saw 21\nSkipping line 120: expected 9 fields, saw 10\nSkipping line 121: expected 9 fields, saw 10\nSkipping line 122: expected 9 fields, saw 10\nSkipping line 123: expected 9 fields, saw 14\nSkipping line 125: expected 9 fields, saw 10\nSkipping line 126: expected 9 fields, saw 15\nSkipping line 128: expected 9 fields, saw 12\nSkipping line 129: expected 9 fields, saw 10\nSkipping line 130: expected 9 fields, saw 16\nSkipping line 131: expected 9 fields, saw 11\nSkipping line 132: expected 9 fields, saw 17\nSkipping line 133: expected 9 fields, saw 17\nSkipping line 134: expected 9 fields, saw 12\nSkipping line 135: expected 9 fields, saw 12\nSkipping line 137: expected 9 fields, saw 12\nSkipping line 139: expected 9 fields, saw 11\nSkipping line 140: expected 9 fields, saw 12\nSkipping line 141: expected 9 fields, saw 15\nSkipping line 142: expected 9 fields, saw 14\nSkipping line 143: expected 9 fields, saw 14\nSkipping line 145: expected 9 fields, saw 13\nSkipping line 146: expected 9 fields, saw 10\nSkipping line 147: expected 9 fields, saw 14\nSkipping line 150: expected 9 fields, saw 12\nSkipping line 152: expected 9 fields, saw 10\nSkipping line 154: expected 9 fields, saw 11\nSkipping line 155: expected 9 fields, saw 11\nSkipping line 156: expected 9 fields, saw 12\nSkipping line 158: expected 9 fields, saw 15\nSkipping line 160: expected 9 fields, saw 10\nSkipping line 161: expected 9 fields, saw 10\nSkipping line 162: expected 9 fields, saw 10\nSkipping line 163: expected 9 fields, saw 30\nSkipping line 165: expected 9 fields, saw 15\nSkipping line 166: expected 9 fields, saw 18\nSkipping line 167: expected 9 fields, saw 29\nSkipping line 168: expected 9 fields, saw 12\nSkipping line 169: expected 9 fields, saw 10\nSkipping line 170: expected 9 fields, saw 46\nSkipping line 172: expected 9 fields, saw 11\nSkipping line 173: expected 9 fields, saw 14\nSkipping line 175: expected 9 fields, saw 10\nSkipping line 177: expected 9 fields, saw 17\nSkipping line 178: expected 9 fields, saw 10\nSkipping line 180: expected 9 fields, saw 12\nSkipping line 181: expected 9 fields, saw 10\nSkipping line 185: expected 9 fields, saw 15\nSkipping line 186: expected 9 fields, saw 12\nSkipping line 187: expected 9 fields, saw 15\nSkipping line 192: expected 9 fields, saw 10\nSkipping line 193: expected 9 fields, saw 10\nSkipping line 197: expected 9 fields, saw 25\nSkipping line 199: expected 9 fields, saw 19\nSkipping line 200: expected 9 fields, saw 12\nSkipping line 201: expected 9 fields, saw 22\nSkipping line 204: expected 9 fields, saw 14\nSkipping line 205: expected 9 fields, saw 13\nSkipping line 206: expected 9 fields, saw 20\nSkipping line 207: expected 9 fields, saw 19\nSkipping line 209: expected 9 fields, saw 10\nSkipping line 212: expected 9 fields, saw 10\nSkipping line 213: expected 9 fields, saw 40\nSkipping line 214: expected 9 fields, saw 13\nSkipping line 215: expected 9 fields, saw 10\nSkipping line 219: expected 9 fields, saw 25\nSkipping line 220: expected 9 fields, saw 29\nSkipping line 221: expected 9 fields, saw 10\nSkipping line 222: expected 9 fields, saw 22\nSkipping line 224: expected 9 fields, saw 11\nSkipping line 225: expected 9 fields, saw 11\nSkipping line 229: expected 9 fields, saw 10\nSkipping line 231: expected 9 fields, saw 24\nSkipping line 232: expected 9 fields, saw 14\nSkipping line 233: expected 9 fields, saw 15\nSkipping line 234: expected 9 fields, saw 13\nSkipping line 235: expected 9 fields, saw 11\nSkipping line 236: expected 9 fields, saw 12\nSkipping line 238: expected 9 fields, saw 13\nSkipping line 240: expected 9 fields, saw 11\nSkipping line 242: expected 9 fields, saw 12\nSkipping line 244: expected 9 fields, saw 17\nSkipping line 245: expected 9 fields, saw 13\nSkipping line 247: expected 9 fields, saw 11\nSkipping line 248: expected 9 fields, saw 11\nSkipping line 250: expected 9 fields, saw 12\nSkipping line 251: expected 9 fields, saw 17\nSkipping line 255: expected 9 fields, saw 10\nSkipping line 259: expected 9 fields, saw 12\nSkipping line 260: expected 9 fields, saw 12\nSkipping line 261: expected 9 fields, saw 10\nSkipping line 263: expected 9 fields, saw 10\nSkipping line 264: expected 9 fields, saw 10\nSkipping line 266: expected 9 fields, saw 12\nSkipping line 271: expected 9 fields, saw 14\nSkipping line 272: expected 9 fields, saw 10\nSkipping line 274: expected 9 fields, saw 11\nSkipping line 283: expected 9 fields, saw 13\nSkipping line 284: expected 9 fields, saw 10\nSkipping line 286: expected 9 fields, saw 19\nSkipping line 287: expected 9 fields, saw 17\nSkipping line 289: expected 9 fields, saw 10\nSkipping line 290: expected 9 fields, saw 12\nSkipping line 293: expected 9 fields, saw 15\nSkipping line 294: expected 9 fields, saw 10\nSkipping line 295: expected 9 fields, saw 10\nSkipping line 297: expected 9 fields, saw 26\nSkipping line 299: expected 9 fields, saw 13\nSkipping line 300: expected 9 fields, saw 14\nSkipping line 302: expected 9 fields, saw 10\nSkipping line 303: expected 9 fields, saw 13\nSkipping line 304: expected 9 fields, saw 10\nSkipping line 306: expected 9 fields, saw 10\nSkipping line 308: expected 9 fields, saw 20\nSkipping line 309: expected 9 fields, saw 11\nSkipping line 310: expected 9 fields, saw 10\nSkipping line 311: expected 9 fields, saw 10\nSkipping line 313: expected 9 fields, saw 10\nSkipping line 314: expected 9 fields, saw 25\nSkipping line 315: expected 9 fields, saw 10\nSkipping line 316: expected 9 fields, saw 28\nSkipping line 318: expected 9 fields, saw 10\nSkipping line 320: expected 9 fields, saw 11\nSkipping line 321: expected 9 fields, saw 11\nSkipping line 323: expected 9 fields, saw 12\nSkipping line 324: expected 9 fields, saw 13\nSkipping line 326: expected 9 fields, saw 23\nSkipping line 328: expected 9 fields, saw 13\nSkipping line 330: expected 9 fields, saw 10\nSkipping line 331: expected 9 fields, saw 11\nSkipping line 332: expected 9 fields, saw 13\nSkipping line 333: expected 9 fields, saw 11\nSkipping line 334: expected 9 fields, saw 12\nSkipping line 336: expected 9 fields, saw 10\nSkipping line 338: expected 9 fields, saw 11\nSkipping line 340: expected 9 fields, saw 10\nSkipping line 343: expected 9 fields, saw 18\nSkipping line 344: expected 9 fields, saw 13\nSkipping line 345: expected 9 fields, saw 12\nSkipping line 346: expected 9 fields, saw 10\nSkipping line 347: expected 9 fields, saw 11\nSkipping line 353: expected 9 fields, saw 12\nSkipping line 355: expected 9 fields, saw 16\nSkipping line 358: expected 9 fields, saw 12\nSkipping line 362: expected 9 fields, saw 11\nSkipping line 363: expected 9 fields, saw 11\nSkipping line 365: expected 9 fields, saw 10\nSkipping line 366: expected 9 fields, saw 10\nSkipping line 367: expected 9 fields, saw 10\nSkipping line 368: expected 9 fields, saw 12\nSkipping line 369: expected 9 fields, saw 11\nSkipping line 372: expected 9 fields, saw 10\nSkipping line 374: expected 9 fields, saw 19\nSkipping line 375: expected 9 fields, saw 10\nSkipping line 376: expected 9 fields, saw 24\nSkipping line 377: expected 9 fields, saw 10\nSkipping line 378: expected 9 fields, saw 13\nSkipping line 379: expected 9 fields, saw 18\nSkipping line 380: expected 9 fields, saw 17\nSkipping line 383: expected 9 fields, saw 10\nSkipping line 384: expected 9 fields, saw 11\nSkipping line 386: expected 9 fields, saw 16\nSkipping line 388: expected 9 fields, saw 10\nSkipping line 389: expected 9 fields, saw 10\nSkipping line 390: expected 9 fields, saw 11\nSkipping line 391: expected 9 fields, saw 25\nSkipping line 394: expected 9 fields, saw 40\nSkipping line 395: expected 9 fields, saw 13\nSkipping line 398: expected 9 fields, saw 11\nSkipping line 400: expected 9 fields, saw 13\nSkipping line 402: expected 9 fields, saw 11\nSkipping line 404: expected 9 fields, saw 11\nSkipping line 406: expected 9 fields, saw 13\nSkipping line 409: expected 9 fields, saw 10\nSkipping line 410: expected 9 fields, saw 24\nSkipping line 411: expected 9 fields, saw 16\nSkipping line 413: expected 9 fields, saw 10\nSkipping line 414: expected 9 fields, saw 23\nSkipping line 415: expected 9 fields, saw 12\nSkipping line 417: expected 9 fields, saw 10\nSkipping line 419: expected 9 fields, saw 24\nSkipping line 421: expected 9 fields, saw 12\nSkipping line 423: expected 9 fields, saw 24\nSkipping line 425: expected 9 fields, saw 11\nSkipping line 427: expected 9 fields, saw 16\nSkipping line 428: expected 9 fields, saw 10\nSkipping line 430: expected 9 fields, saw 12\nSkipping line 431: expected 9 fields, saw 11\nSkipping line 437: expected 9 fields, saw 14\nSkipping line 438: expected 9 fields, saw 13\nSkipping line 439: expected 9 fields, saw 17\nSkipping line 440: expected 9 fields, saw 10\nSkipping line 441: expected 9 fields, saw 15\nSkipping line 442: expected 9 fields, saw 13\nSkipping line 443: expected 9 fields, saw 10\nSkipping line 445: expected 9 fields, saw 15\nSkipping line 446: expected 9 fields, saw 10\nSkipping line 449: expected 9 fields, saw 12\nSkipping line 451: expected 9 fields, saw 13\nSkipping line 456: expected 9 fields, saw 12\nSkipping line 457: expected 9 fields, saw 16\nSkipping line 459: expected 9 fields, saw 14\nSkipping line 460: expected 9 fields, saw 22\nSkipping line 461: expected 9 fields, saw 10\nSkipping line 464: expected 9 fields, saw 12\nSkipping line 465: expected 9 fields, saw 13\nSkipping line 466: expected 9 fields, saw 11\nSkipping line 468: expected 9 fields, saw 18\nSkipping line 471: expected 9 fields, saw 10\nSkipping line 474: expected 9 fields, saw 11\nSkipping line 477: expected 9 fields, saw 12\nSkipping line 478: expected 9 fields, saw 24\nSkipping line 479: expected 9 fields, saw 10\nSkipping line 481: expected 9 fields, saw 10\nSkipping line 483: expected 9 fields, saw 10\nSkipping line 484: expected 9 fields, saw 11\nSkipping line 485: expected 9 fields, saw 21\nSkipping line 486: expected 9 fields, saw 13\nSkipping line 488: expected 9 fields, saw 11\nSkipping line 491: expected 9 fields, saw 14\nSkipping line 492: expected 9 fields, saw 10\nSkipping line 493: expected 9 fields, saw 25\nSkipping line 494: expected 9 fields, saw 41\nSkipping line 495: expected 9 fields, saw 12\nSkipping line 499: expected 9 fields, saw 10\nSkipping line 500: expected 9 fields, saw 19\nSkipping line 502: expected 9 fields, saw 23\nSkipping line 505: expected 9 fields, saw 17\nSkipping line 506: expected 9 fields, saw 10\nSkipping line 508: expected 9 fields, saw 12\nSkipping line 510: expected 9 fields, saw 11\nSkipping line 512: expected 9 fields, saw 11\nSkipping line 514: expected 9 fields, saw 28\nSkipping line 517: expected 9 fields, saw 21\nSkipping line 518: expected 9 fields, saw 10\nSkipping line 520: expected 9 fields, saw 15\nSkipping line 522: expected 9 fields, saw 10\nSkipping line 523: expected 9 fields, saw 16\nSkipping line 524: expected 9 fields, saw 14\nSkipping line 525: expected 9 fields, saw 36\nSkipping line 527: expected 9 fields, saw 23\nSkipping line 530: expected 9 fields, saw 10\nSkipping line 531: expected 9 fields, saw 18\nSkipping line 532: expected 9 fields, saw 12\nSkipping line 535: expected 9 fields, saw 14\nSkipping line 538: expected 9 fields, saw 11\nSkipping line 540: expected 9 fields, saw 21\nSkipping line 542: expected 9 fields, saw 10\nSkipping line 544: expected 9 fields, saw 12\nSkipping line 546: expected 9 fields, saw 24\nSkipping line 547: expected 9 fields, saw 10\nSkipping line 549: expected 9 fields, saw 11\nSkipping line 550: expected 9 fields, saw 12\nSkipping line 553: expected 9 fields, saw 11\nSkipping line 555: expected 9 fields, saw 14\nSkipping line 556: expected 9 fields, saw 11\nSkipping line 557: expected 9 fields, saw 11\nSkipping line 558: expected 9 fields, saw 10\nSkipping line 559: expected 9 fields, saw 33\nSkipping line 560: expected 9 fields, saw 10\nSkipping line 561: expected 9 fields, saw 13\nSkipping line 562: expected 9 fields, saw 10\nSkipping line 563: expected 9 fields, saw 12\nSkipping line 565: expected 9 fields, saw 25\nSkipping line 566: expected 9 fields, saw 12\nSkipping line 567: expected 9 fields, saw 24\nSkipping line 568: expected 9 fields, saw 10\nSkipping line 569: expected 9 fields, saw 23\nSkipping line 570: expected 9 fields, saw 12\nSkipping line 571: expected 9 fields, saw 11\nSkipping line 575: expected 9 fields, saw 16\nSkipping line 576: expected 9 fields, saw 14\nSkipping line 577: expected 9 fields, saw 34\nSkipping line 580: expected 9 fields, saw 16\nSkipping line 581: expected 9 fields, saw 25\nSkipping line 583: expected 9 fields, saw 11\nSkipping line 587: expected 9 fields, saw 23\nSkipping line 588: expected 9 fields, saw 10\nSkipping line 590: expected 9 fields, saw 11\nSkipping line 591: expected 9 fields, saw 10\nSkipping line 592: expected 9 fields, saw 26\nSkipping line 593: expected 9 fields, saw 11\nSkipping line 594: expected 9 fields, saw 19\nSkipping line 595: expected 9 fields, saw 10\nSkipping line 596: expected 9 fields, saw 12\nSkipping line 598: expected 9 fields, saw 15\nSkipping line 599: expected 9 fields, saw 20\nSkipping line 601: expected 9 fields, saw 11\nSkipping line 602: expected 9 fields, saw 12\nSkipping line 603: expected 9 fields, saw 10\nSkipping line 604: expected 9 fields, saw 19\nSkipping line 605: expected 9 fields, saw 12\nSkipping line 606: expected 9 fields, saw 10\nSkipping line 607: expected 9 fields, saw 10\nSkipping line 613: expected 9 fields, saw 14\nSkipping line 618: expected 9 fields, saw 16\nSkipping line 620: expected 9 fields, saw 23\nSkipping line 621: expected 9 fields, saw 18\nSkipping line 622: expected 9 fields, saw 13\nSkipping line 623: expected 9 fields, saw 18\nSkipping line 624: expected 9 fields, saw 10\nSkipping line 626: expected 9 fields, saw 23\nSkipping line 627: expected 9 fields, saw 23\nSkipping line 628: expected 9 fields, saw 10\nSkipping line 629: expected 9 fields, saw 10\nSkipping line 631: expected 9 fields, saw 13\nSkipping line 632: expected 9 fields, saw 15\nSkipping line 634: expected 9 fields, saw 11\nSkipping line 636: expected 9 fields, saw 10\nSkipping line 638: expected 9 fields, saw 11\nSkipping line 639: expected 9 fields, saw 23\nSkipping line 640: expected 9 fields, saw 11\nSkipping line 643: expected 9 fields, saw 10\nSkipping line 644: expected 9 fields, saw 14\nSkipping line 645: expected 9 fields, saw 25\nSkipping line 649: expected 9 fields, saw 12\nSkipping line 651: expected 9 fields, saw 12\nSkipping line 652: expected 9 fields, saw 10\nSkipping line 655: expected 9 fields, saw 19\nSkipping line 656: expected 9 fields, saw 11\nSkipping line 658: expected 9 fields, saw 11\nSkipping line 660: expected 9 fields, saw 10\nSkipping line 663: expected 9 fields, saw 17\nSkipping line 664: expected 9 fields, saw 10\nSkipping line 665: expected 9 fields, saw 25\nSkipping line 666: expected 9 fields, saw 44\nSkipping line 669: expected 9 fields, saw 32\nSkipping line 670: expected 9 fields, saw 10\nSkipping line 673: expected 9 fields, saw 11\nSkipping line 676: expected 9 fields, saw 11\nSkipping line 677: expected 9 fields, saw 16\nSkipping line 678: expected 9 fields, saw 10\nSkipping line 681: expected 9 fields, saw 18\nSkipping line 683: expected 9 fields, saw 10\nSkipping line 684: expected 9 fields, saw 13\nSkipping line 685: expected 9 fields, saw 12\nSkipping line 686: expected 9 fields, saw 21\nSkipping line 687: expected 9 fields, saw 10\nSkipping line 688: expected 9 fields, saw 12\nSkipping line 689: expected 9 fields, saw 16\nSkipping line 690: expected 9 fields, saw 10\nSkipping line 692: expected 9 fields, saw 10\nSkipping line 693: expected 9 fields, saw 11\nSkipping line 694: expected 9 fields, saw 13\nSkipping line 697: expected 9 fields, saw 25\nSkipping line 698: expected 9 fields, saw 28\nSkipping line 699: expected 9 fields, saw 20\nSkipping line 700: expected 9 fields, saw 10\nSkipping line 701: expected 9 fields, saw 13\nSkipping line 702: expected 9 fields, saw 11\nSkipping line 704: expected 9 fields, saw 15\nSkipping line 705: expected 9 fields, saw 21\nSkipping line 706: expected 9 fields, saw 19\nSkipping line 707: expected 9 fields, saw 10\nSkipping line 708: expected 9 fields, saw 15\nSkipping line 709: expected 9 fields, saw 10\nSkipping line 714: expected 9 fields, saw 14\nSkipping line 717: expected 9 fields, saw 16\nSkipping line 718: expected 9 fields, saw 14\nSkipping line 720: expected 9 fields, saw 23\nSkipping line 723: expected 9 fields, saw 10\nSkipping line 725: expected 9 fields, saw 10\nSkipping line 727: expected 9 fields, saw 12\nSkipping line 728: expected 9 fields, saw 11\nSkipping line 731: expected 9 fields, saw 10\nSkipping line 733: expected 9 fields, saw 10\nSkipping line 735: expected 9 fields, saw 16\nSkipping line 736: expected 9 fields, saw 11\nSkipping line 737: expected 9 fields, saw 26\nSkipping line 738: expected 9 fields, saw 22\nSkipping line 739: expected 9 fields, saw 10\nSkipping line 740: expected 9 fields, saw 10\nSkipping line 741: expected 9 fields, saw 11\nSkipping line 742: expected 9 fields, saw 11\nSkipping line 743: expected 9 fields, saw 14\nSkipping line 745: expected 9 fields, saw 10\nSkipping line 747: expected 9 fields, saw 13\nSkipping line 749: expected 9 fields, saw 10\nSkipping line 750: expected 9 fields, saw 11\nSkipping line 753: expected 9 fields, saw 20\nSkipping line 754: expected 9 fields, saw 10\nSkipping line 755: expected 9 fields, saw 10\nSkipping line 756: expected 9 fields, saw 11\nSkipping line 757: expected 9 fields, saw 10\nSkipping line 758: expected 9 fields, saw 10\nSkipping line 761: expected 9 fields, saw 10\nSkipping line 762: expected 9 fields, saw 11\nSkipping line 763: expected 9 fields, saw 21\nSkipping line 764: expected 9 fields, saw 11\nSkipping line 765: expected 9 fields, saw 15\nSkipping line 766: expected 9 fields, saw 26\nSkipping line 767: expected 9 fields, saw 13\nSkipping line 768: expected 9 fields, saw 10\nSkipping line 772: expected 9 fields, saw 14\nSkipping line 773: expected 9 fields, saw 10\nSkipping line 775: expected 9 fields, saw 18\nSkipping line 779: expected 9 fields, saw 13\nSkipping line 781: expected 9 fields, saw 13\nSkipping line 783: expected 9 fields, saw 10\nSkipping line 784: expected 9 fields, saw 16\nSkipping line 788: expected 9 fields, saw 11\nSkipping line 789: expected 9 fields, saw 10\nSkipping line 790: expected 9 fields, saw 10\nSkipping line 791: expected 9 fields, saw 14\nSkipping line 792: expected 9 fields, saw 13\nSkipping line 793: expected 9 fields, saw 11\nSkipping line 794: expected 9 fields, saw 11\nSkipping line 795: expected 9 fields, saw 50\nSkipping line 796: expected 9 fields, saw 10\nSkipping line 799: expected 9 fields, saw 25\nSkipping line 803: expected 9 fields, saw 24\nSkipping line 804: expected 9 fields, saw 15\nSkipping line 805: expected 9 fields, saw 11\nSkipping line 806: expected 9 fields, saw 16\nSkipping line 807: expected 9 fields, saw 10\nSkipping line 808: expected 9 fields, saw 10\nSkipping line 809: expected 9 fields, saw 10\nSkipping line 813: expected 9 fields, saw 23\nSkipping line 815: expected 9 fields, saw 19\nSkipping line 817: expected 9 fields, saw 11\nSkipping line 819: expected 9 fields, saw 10\nSkipping line 821: expected 9 fields, saw 10\nSkipping line 825: expected 9 fields, saw 23\nSkipping line 826: expected 9 fields, saw 12\nSkipping line 827: expected 9 fields, saw 11\nSkipping line 828: expected 9 fields, saw 11\nSkipping line 829: expected 9 fields, saw 26\nSkipping line 831: expected 9 fields, saw 11\nSkipping line 832: expected 9 fields, saw 21\nSkipping line 833: expected 9 fields, saw 11\nSkipping line 834: expected 9 fields, saw 11\nSkipping line 835: expected 9 fields, saw 11\nSkipping line 837: expected 9 fields, saw 17\nSkipping line 838: expected 9 fields, saw 24\nSkipping line 839: expected 9 fields, saw 11\nSkipping line 841: expected 9 fields, saw 10\nSkipping line 842: expected 9 fields, saw 25\nSkipping line 844: expected 9 fields, saw 25\nSkipping line 845: expected 9 fields, saw 12\nSkipping line 847: expected 9 fields, saw 24\nSkipping line 848: expected 9 fields, saw 13\nSkipping line 849: expected 9 fields, saw 13\nSkipping line 851: expected 9 fields, saw 12\nSkipping line 852: expected 9 fields, saw 11\nSkipping line 854: expected 9 fields, saw 17\nSkipping line 857: expected 9 fields, saw 29\nSkipping line 860: expected 9 fields, saw 11\nSkipping line 861: expected 9 fields, saw 10\nSkipping line 862: expected 9 fields, saw 11\nSkipping line 863: expected 9 fields, saw 11\nSkipping line 864: expected 9 fields, saw 10\nSkipping line 865: expected 9 fields, saw 16\nSkipping line 866: expected 9 fields, saw 13\nSkipping line 867: expected 9 fields, saw 11\nSkipping line 868: expected 9 fields, saw 21\nSkipping line 870: expected 9 fields, saw 10\nSkipping line 871: expected 9 fields, saw 12\nSkipping line 872: expected 9 fields, saw 10\nSkipping line 873: expected 9 fields, saw 10\nSkipping line 874: expected 9 fields, saw 10\nSkipping line 875: expected 9 fields, saw 11\nSkipping line 876: expected 9 fields, saw 18\nSkipping line 878: expected 9 fields, saw 13\nSkipping line 879: expected 9 fields, saw 12\nSkipping line 880: expected 9 fields, saw 10\nSkipping line 881: expected 9 fields, saw 10\nSkipping line 887: expected 9 fields, saw 26\nSkipping line 890: expected 9 fields, saw 22\nSkipping line 892: expected 9 fields, saw 10\nSkipping line 894: expected 9 fields, saw 10\nSkipping line 895: expected 9 fields, saw 10\nSkipping line 897: expected 9 fields, saw 22\nSkipping line 899: expected 9 fields, saw 10\nSkipping line 902: expected 9 fields, saw 10\nSkipping line 903: expected 9 fields, saw 27\nSkipping line 904: expected 9 fields, saw 18\nSkipping line 906: expected 9 fields, saw 11\nSkipping line 907: expected 9 fields, saw 10\nSkipping line 911: expected 9 fields, saw 10\nSkipping line 912: expected 9 fields, saw 10\nSkipping line 914: expected 9 fields, saw 11\nSkipping line 916: expected 9 fields, saw 10\nSkipping line 917: expected 9 fields, saw 11\nSkipping line 918: expected 9 fields, saw 11\nSkipping line 919: expected 9 fields, saw 12\nSkipping line 920: expected 9 fields, saw 43\nSkipping line 921: expected 9 fields, saw 11\nSkipping line 922: expected 9 fields, saw 12\nSkipping line 923: expected 9 fields, saw 10\nSkipping line 927: expected 9 fields, saw 13\nSkipping line 928: expected 9 fields, saw 10\nSkipping line 929: expected 9 fields, saw 21\nSkipping line 933: expected 9 fields, saw 10\nSkipping line 934: expected 9 fields, saw 11\nSkipping line 935: expected 9 fields, saw 11\nSkipping line 936: expected 9 fields, saw 12\nSkipping line 937: expected 9 fields, saw 11\nSkipping line 938: expected 9 fields, saw 10\nSkipping line 939: expected 9 fields, saw 11\nSkipping line 940: expected 9 fields, saw 13\nSkipping line 941: expected 9 fields, saw 21\nSkipping line 942: expected 9 fields, saw 26\nSkipping line 943: expected 9 fields, saw 25\nSkipping line 944: expected 9 fields, saw 22\nSkipping line 945: expected 9 fields, saw 13\nSkipping line 946: expected 9 fields, saw 12\nSkipping line 948: expected 9 fields, saw 16\nSkipping line 949: expected 9 fields, saw 12\nSkipping line 950: expected 9 fields, saw 11\nSkipping line 952: expected 9 fields, saw 19\nSkipping line 953: expected 9 fields, saw 10\nSkipping line 954: expected 9 fields, saw 10\nSkipping line 957: expected 9 fields, saw 19\nSkipping line 960: expected 9 fields, saw 13\nSkipping line 961: expected 9 fields, saw 10\nSkipping line 963: expected 9 fields, saw 13\nSkipping line 964: expected 9 fields, saw 22\nSkipping line 965: expected 9 fields, saw 10\nSkipping line 969: expected 9 fields, saw 11\nSkipping line 970: expected 9 fields, saw 10\nSkipping line 974: expected 9 fields, saw 10\nSkipping line 975: expected 9 fields, saw 18\nSkipping line 976: expected 9 fields, saw 16\nSkipping line 977: expected 9 fields, saw 17\nSkipping line 978: expected 9 fields, saw 18\nSkipping line 979: expected 9 fields, saw 10\nSkipping line 980: expected 9 fields, saw 11\nSkipping line 981: expected 9 fields, saw 11\nSkipping line 983: expected 9 fields, saw 10\nSkipping line 984: expected 9 fields, saw 10\nSkipping line 985: expected 9 fields, saw 11\nSkipping line 988: expected 9 fields, saw 10\nSkipping line 989: expected 9 fields, saw 10\nSkipping line 991: expected 9 fields, saw 10\nSkipping line 992: expected 9 fields, saw 16\nSkipping line 993: expected 9 fields, saw 10\nSkipping line 994: expected 9 fields, saw 13\nSkipping line 995: expected 9 fields, saw 11\nSkipping line 997: expected 9 fields, saw 18\nSkipping line 999: expected 9 fields, saw 10\nSkipping line 1000: expected 9 fields, saw 16\nSkipping line 1002: expected 9 fields, saw 14\nSkipping line 1003: expected 9 fields, saw 13\nSkipping line 1008: expected 9 fields, saw 14\nSkipping line 1013: expected 9 fields, saw 11\nSkipping line 1015: expected 9 fields, saw 25\nSkipping line 1018: expected 9 fields, saw 11\nSkipping line 1019: expected 9 fields, saw 10\nSkipping line 1020: expected 9 fields, saw 10\nSkipping line 1021: expected 9 fields, saw 10\nSkipping line 1022: expected 9 fields, saw 10\nSkipping line 1023: expected 9 fields, saw 10\nSkipping line 1024: expected 9 fields, saw 15\nSkipping line 1025: expected 9 fields, saw 16\nSkipping line 1027: expected 9 fields, saw 25\nSkipping line 1028: expected 9 fields, saw 13\nSkipping line 1029: expected 9 fields, saw 12\nSkipping line 1030: expected 9 fields, saw 10\nSkipping line 1031: expected 9 fields, saw 10\nSkipping line 1033: expected 9 fields, saw 26\nSkipping line 1034: expected 9 fields, saw 34\nSkipping line 1036: expected 9 fields, saw 24\nSkipping line 1039: expected 9 fields, saw 41\nSkipping line 1040: expected 9 fields, saw 14\nSkipping line 1044: expected 9 fields, saw 16\nSkipping line 1046: expected 9 fields, saw 22\nSkipping line 1047: expected 9 fields, saw 13\nSkipping line 1048: expected 9 fields, saw 14\nSkipping line 1049: expected 9 fields, saw 23\nSkipping line 1050: expected 9 fields, saw 10\nSkipping line 1051: expected 9 fields, saw 13\nSkipping line 1052: expected 9 fields, saw 10\nSkipping line 1054: expected 9 fields, saw 10\nSkipping line 1056: expected 9 fields, saw 10\nSkipping line 1057: expected 9 fields, saw 11\nSkipping line 1058: expected 9 fields, saw 10\nSkipping line 1059: expected 9 fields, saw 18\nSkipping line 1061: expected 9 fields, saw 16\nSkipping line 1062: expected 9 fields, saw 13\nSkipping line 1063: expected 9 fields, saw 11\nSkipping line 1065: expected 9 fields, saw 10\nSkipping line 1066: expected 9 fields, saw 13\nSkipping line 1067: expected 9 fields, saw 12\nSkipping line 1069: expected 9 fields, saw 11\nSkipping line 1070: expected 9 fields, saw 10\nSkipping line 1071: expected 9 fields, saw 10\nSkipping line 1072: expected 9 fields, saw 41\nSkipping line 1073: expected 9 fields, saw 12\nSkipping line 1074: expected 9 fields, saw 15\nSkipping line 1075: expected 9 fields, saw 10\nSkipping line 1079: expected 9 fields, saw 10\nSkipping line 1080: expected 9 fields, saw 20\nSkipping line 1081: expected 9 fields, saw 24\nSkipping line 1082: expected 9 fields, saw 20\nSkipping line 1083: expected 9 fields, saw 13\nSkipping line 1084: expected 9 fields, saw 11\nSkipping line 1085: expected 9 fields, saw 22\nSkipping line 1086: expected 9 fields, saw 15\nSkipping line 1087: expected 9 fields, saw 10\nSkipping line 1089: expected 9 fields, saw 18\nSkipping line 1091: expected 9 fields, saw 10\nSkipping line 1092: expected 9 fields, saw 19\nSkipping line 1094: expected 9 fields, saw 14\nSkipping line 1096: expected 9 fields, saw 12\nSkipping line 1097: expected 9 fields, saw 19\nSkipping line 1098: expected 9 fields, saw 11\nSkipping line 1099: expected 9 fields, saw 16\nSkipping line 1100: expected 9 fields, saw 13\nSkipping line 1103: expected 9 fields, saw 11\nSkipping line 1105: expected 9 fields, saw 13\nSkipping line 1109: expected 9 fields, saw 11\nSkipping line 1113: expected 9 fields, saw 25\nSkipping line 1115: expected 9 fields, saw 23\nSkipping line 1117: expected 9 fields, saw 25\nSkipping line 1118: expected 9 fields, saw 11\nSkipping line 1121: expected 9 fields, saw 13\nSkipping line 1124: expected 9 fields, saw 12\nSkipping line 1125: expected 9 fields, saw 13\nSkipping line 1126: expected 9 fields, saw 13\nSkipping line 1127: expected 9 fields, saw 26\nSkipping line 1128: expected 9 fields, saw 11\nSkipping line 1129: expected 9 fields, saw 10\nSkipping line 1130: expected 9 fields, saw 10\nSkipping line 1132: expected 9 fields, saw 18\nSkipping line 1135: expected 9 fields, saw 11\nSkipping line 1138: expected 9 fields, saw 11\nSkipping line 1141: expected 9 fields, saw 10\nSkipping line 1142: expected 9 fields, saw 10\nSkipping line 1143: expected 9 fields, saw 24\nSkipping line 1145: expected 9 fields, saw 12\nSkipping line 1148: expected 9 fields, saw 12\nSkipping line 1149: expected 9 fields, saw 10\nSkipping line 1151: expected 9 fields, saw 27\nSkipping line 1152: expected 9 fields, saw 11\nSkipping line 1153: expected 9 fields, saw 10\nSkipping line 1154: expected 9 fields, saw 10\nSkipping line 1155: expected 9 fields, saw 46\nSkipping line 1159: expected 9 fields, saw 11\nSkipping line 1160: expected 9 fields, saw 13\nSkipping line 1161: expected 9 fields, saw 16\nSkipping line 1162: expected 9 fields, saw 10\nSkipping line 1164: expected 9 fields, saw 36\nSkipping line 1168: expected 9 fields, saw 13\nSkipping line 1169: expected 9 fields, saw 20\nSkipping line 1170: expected 9 fields, saw 10\nSkipping line 1171: expected 9 fields, saw 10\nSkipping line 1172: expected 9 fields, saw 11\nSkipping line 1175: expected 9 fields, saw 11\nSkipping line 1177: expected 9 fields, saw 15\nSkipping line 1178: expected 9 fields, saw 25\nSkipping line 1179: expected 9 fields, saw 11\nSkipping line 1180: expected 9 fields, saw 10\nSkipping line 1181: expected 9 fields, saw 10\nSkipping line 1183: expected 9 fields, saw 14\nSkipping line 1184: expected 9 fields, saw 10\nSkipping line 1188: expected 9 fields, saw 17\nSkipping line 1189: expected 9 fields, saw 11\nSkipping line 1191: expected 9 fields, saw 10\nSkipping line 1192: expected 9 fields, saw 16\nSkipping line 1193: expected 9 fields, saw 11\nSkipping line 1194: expected 9 fields, saw 10\nSkipping line 1195: expected 9 fields, saw 13\nSkipping line 1196: expected 9 fields, saw 10\nSkipping line 1198: expected 9 fields, saw 12\nSkipping line 1199: expected 9 fields, saw 14\nSkipping line 1201: expected 9 fields, saw 10\nSkipping line 1202: expected 9 fields, saw 50\nSkipping line 1205: expected 9 fields, saw 10\nSkipping line 1206: expected 9 fields, saw 22\nSkipping line 1207: expected 9 fields, saw 11\nSkipping line 1208: expected 9 fields, saw 12\nSkipping line 1209: expected 9 fields, saw 11\nSkipping line 1210: expected 9 fields, saw 23\nSkipping line 1211: expected 9 fields, saw 17\nSkipping line 1212: expected 9 fields, saw 13\nSkipping line 1214: expected 9 fields, saw 18\nSkipping line 1215: expected 9 fields, saw 19\nSkipping line 1216: expected 9 fields, saw 10\nSkipping line 1217: expected 9 fields, saw 11\nSkipping line 1218: expected 9 fields, saw 13\nSkipping line 1219: expected 9 fields, saw 12\nSkipping line 1220: expected 9 fields, saw 11\nSkipping line 1221: expected 9 fields, saw 11\nSkipping line 1223: expected 9 fields, saw 12\nSkipping line 1224: expected 9 fields, saw 10\nSkipping line 1225: expected 9 fields, saw 18\nSkipping line 1226: expected 9 fields, saw 10\nSkipping line 1227: expected 9 fields, saw 12\nSkipping line 1228: expected 9 fields, saw 16\nSkipping line 1229: expected 9 fields, saw 12\nSkipping line 1232: expected 9 fields, saw 11\nSkipping line 1233: expected 9 fields, saw 10\nSkipping line 1234: expected 9 fields, saw 15\nSkipping line 1235: expected 9 fields, saw 10\nSkipping line 1236: expected 9 fields, saw 19\nSkipping line 1237: expected 9 fields, saw 12\nSkipping line 1238: expected 9 fields, saw 12\nSkipping line 1239: expected 9 fields, saw 10\nSkipping line 1240: expected 9 fields, saw 10\nSkipping line 1241: expected 9 fields, saw 10\nSkipping line 1242: expected 9 fields, saw 16\nSkipping line 1243: expected 9 fields, saw 18\nSkipping line 1244: expected 9 fields, saw 16\nSkipping line 1245: expected 9 fields, saw 10\nSkipping line 1246: expected 9 fields, saw 17\nSkipping line 1249: expected 9 fields, saw 11\nSkipping line 1250: expected 9 fields, saw 13\nSkipping line 1251: expected 9 fields, saw 10\nSkipping line 1253: expected 9 fields, saw 18\nSkipping line 1254: expected 9 fields, saw 10\nSkipping line 1255: expected 9 fields, saw 10\nSkipping line 1257: expected 9 fields, saw 10\nSkipping line 1258: expected 9 fields, saw 10\nSkipping line 1260: expected 9 fields, saw 20\nSkipping line 1262: expected 9 fields, saw 53\nSkipping line 1264: expected 9 fields, saw 27\nSkipping line 1265: expected 9 fields, saw 10\nSkipping line 1269: expected 9 fields, saw 11\nSkipping line 1271: expected 9 fields, saw 14\nSkipping line 1272: expected 9 fields, saw 15\nSkipping line 1273: expected 9 fields, saw 11\nSkipping line 1274: expected 9 fields, saw 11\nSkipping line 1278: expected 9 fields, saw 18\nSkipping line 1279: expected 9 fields, saw 11\nSkipping line 1280: expected 9 fields, saw 16\nSkipping line 1281: expected 9 fields, saw 12\nSkipping line 1282: expected 9 fields, saw 10\nSkipping line 1284: expected 9 fields, saw 10\nSkipping line 1285: expected 9 fields, saw 10\nSkipping line 1286: expected 9 fields, saw 13\nSkipping line 1287: expected 9 fields, saw 11\nSkipping line 1288: expected 9 fields, saw 11\nSkipping line 1290: expected 9 fields, saw 22\nSkipping line 1292: expected 9 fields, saw 11\nSkipping line 1293: expected 9 fields, saw 13\nSkipping line 1294: expected 9 fields, saw 10\nSkipping line 1297: expected 9 fields, saw 17\nSkipping line 1298: expected 9 fields, saw 25\nSkipping line 1299: expected 9 fields, saw 23\nSkipping line 1300: expected 9 fields, saw 17\nSkipping line 1301: expected 9 fields, saw 49\nSkipping line 1303: expected 9 fields, saw 12\nSkipping line 1304: expected 9 fields, saw 11\nSkipping line 1305: expected 9 fields, saw 12\nSkipping line 1306: expected 9 fields, saw 11\nSkipping line 1308: expected 9 fields, saw 10\nSkipping line 1311: expected 9 fields, saw 16\nSkipping line 1312: expected 9 fields, saw 11\nSkipping line 1313: expected 9 fields, saw 11\nSkipping line 1314: expected 9 fields, saw 11\nSkipping line 1315: expected 9 fields, saw 10\nSkipping line 1316: expected 9 fields, saw 10\nSkipping line 1317: expected 9 fields, saw 14\nSkipping line 1319: expected 9 fields, saw 13\nSkipping line 1320: expected 9 fields, saw 12\nSkipping line 1321: expected 9 fields, saw 11\nSkipping line 1323: expected 9 fields, saw 10\nSkipping line 1326: expected 9 fields, saw 10\nSkipping line 1327: expected 9 fields, saw 19\nSkipping line 1328: expected 9 fields, saw 11\nSkipping line 1329: expected 9 fields, saw 11\nSkipping line 1331: expected 9 fields, saw 10\nSkipping line 1334: expected 9 fields, saw 23\nSkipping line 1337: expected 9 fields, saw 12\nSkipping line 1338: expected 9 fields, saw 13\nSkipping line 1340: expected 9 fields, saw 11\nSkipping line 1341: expected 9 fields, saw 21\nSkipping line 1342: expected 9 fields, saw 12\nSkipping line 1344: expected 9 fields, saw 10\nSkipping line 1345: expected 9 fields, saw 15\nSkipping line 1348: expected 9 fields, saw 12\nSkipping line 1350: expected 9 fields, saw 10\nSkipping line 1351: expected 9 fields, saw 11\nSkipping line 1352: expected 9 fields, saw 10\nSkipping line 1353: expected 9 fields, saw 13\nSkipping line 1354: expected 9 fields, saw 11\nSkipping line 1355: expected 9 fields, saw 26\nSkipping line 1356: expected 9 fields, saw 15\nSkipping line 1358: expected 9 fields, saw 15\nSkipping line 1359: expected 9 fields, saw 10\nSkipping line 1363: expected 9 fields, saw 17\nSkipping line 1364: expected 9 fields, saw 14\nSkipping line 1365: expected 9 fields, saw 12\nSkipping line 1366: expected 9 fields, saw 13\nSkipping line 1368: expected 9 fields, saw 10\nSkipping line 1370: expected 9 fields, saw 11\nSkipping line 1373: expected 9 fields, saw 13\nSkipping line 1375: expected 9 fields, saw 16\nSkipping line 1376: expected 9 fields, saw 25\nSkipping line 1377: expected 9 fields, saw 24\nSkipping line 1378: expected 9 fields, saw 11\nSkipping line 1379: expected 9 fields, saw 11\nSkipping line 1381: expected 9 fields, saw 12\nSkipping line 1383: expected 9 fields, saw 10\nSkipping line 1384: expected 9 fields, saw 11\nSkipping line 1385: expected 9 fields, saw 14\nSkipping line 1389: expected 9 fields, saw 10\nSkipping line 1390: expected 9 fields, saw 10\nSkipping line 1391: expected 9 fields, saw 11\nSkipping line 1394: expected 9 fields, saw 12\nSkipping line 1395: expected 9 fields, saw 11\nSkipping line 1397: expected 9 fields, saw 12\nSkipping line 1399: expected 9 fields, saw 10\nSkipping line 1400: expected 9 fields, saw 12\nSkipping line 1402: expected 9 fields, saw 11\nSkipping line 1403: expected 9 fields, saw 20\nSkipping line 1405: expected 9 fields, saw 19\nSkipping line 1409: expected 9 fields, saw 10\nSkipping line 1411: expected 9 fields, saw 10\nSkipping line 1412: expected 9 fields, saw 13\nSkipping line 1414: expected 9 fields, saw 12\nSkipping line 1421: expected 9 fields, saw 10\nSkipping line 1422: expected 9 fields, saw 17\nSkipping line 1423: expected 9 fields, saw 10\nSkipping line 1425: expected 9 fields, saw 10\nSkipping line 1426: expected 9 fields, saw 10\nSkipping line 1427: expected 9 fields, saw 13\nSkipping line 1428: expected 9 fields, saw 17\nSkipping line 1429: expected 9 fields, saw 12\nSkipping line 1434: expected 9 fields, saw 10\nSkipping line 1439: expected 9 fields, saw 11\nSkipping line 1440: expected 9 fields, saw 12\nSkipping line 1441: expected 9 fields, saw 10\nSkipping line 1442: expected 9 fields, saw 12\nSkipping line 1443: expected 9 fields, saw 10\nSkipping line 1447: expected 9 fields, saw 10\nSkipping line 1448: expected 9 fields, saw 12\nSkipping line 1450: expected 9 fields, saw 24\nSkipping line 1451: expected 9 fields, saw 24\nSkipping line 1452: expected 9 fields, saw 16\nSkipping line 1453: expected 9 fields, saw 11\nSkipping line 1457: expected 9 fields, saw 16\nSkipping line 1458: expected 9 fields, saw 41\nSkipping line 1460: expected 9 fields, saw 29\nSkipping line 1461: expected 9 fields, saw 24\nSkipping line 1462: expected 9 fields, saw 11\nSkipping line 1464: expected 9 fields, saw 10\nSkipping line 1465: expected 9 fields, saw 12\nSkipping line 1468: expected 9 fields, saw 10\nSkipping line 1469: expected 9 fields, saw 11\nSkipping line 1470: expected 9 fields, saw 12\nSkipping line 1471: expected 9 fields, saw 10\nSkipping line 1475: expected 9 fields, saw 10\nSkipping line 1478: expected 9 fields, saw 23\nSkipping line 1479: expected 9 fields, saw 10\nSkipping line 1480: expected 9 fields, saw 11\nSkipping line 1486: expected 9 fields, saw 21\nSkipping line 1488: expected 9 fields, saw 25\nSkipping line 1489: expected 9 fields, saw 11\nSkipping line 1490: expected 9 fields, saw 16\nSkipping line 1491: expected 9 fields, saw 10\nSkipping line 1492: expected 9 fields, saw 34\nSkipping line 1493: expected 9 fields, saw 12\nSkipping line 1494: expected 9 fields, saw 11\nSkipping line 1495: expected 9 fields, saw 10\nSkipping line 1496: expected 9 fields, saw 22\nSkipping line 1501: expected 9 fields, saw 12\nSkipping line 1502: expected 9 fields, saw 35\nSkipping line 1503: expected 9 fields, saw 10\nSkipping line 1504: expected 9 fields, saw 10\nSkipping line 1505: expected 9 fields, saw 23\nSkipping line 1507: expected 9 fields, saw 10\nSkipping line 1508: expected 9 fields, saw 10\nSkipping line 1509: expected 9 fields, saw 10\nSkipping line 1510: expected 9 fields, saw 11\nSkipping line 1511: expected 9 fields, saw 26\nSkipping line 1512: expected 9 fields, saw 10\nSkipping line 1516: expected 9 fields, saw 19\nSkipping line 1518: expected 9 fields, saw 10\nSkipping line 1520: expected 9 fields, saw 11\nSkipping line 1521: expected 9 fields, saw 25\nSkipping line 1526: expected 9 fields, saw 12\nSkipping line 1528: expected 9 fields, saw 13\nSkipping line 1529: expected 9 fields, saw 10\nSkipping line 1535: expected 9 fields, saw 10\nSkipping line 1536: expected 9 fields, saw 18\nSkipping line 1538: expected 9 fields, saw 11\nSkipping line 1541: expected 9 fields, saw 10\nSkipping line 1542: expected 9 fields, saw 22\nSkipping line 1544: expected 9 fields, saw 24\nSkipping line 1545: expected 9 fields, saw 10\nSkipping line 1546: expected 9 fields, saw 14\nSkipping line 1548: expected 9 fields, saw 13\nSkipping line 1549: expected 9 fields, saw 10\nSkipping line 1551: expected 9 fields, saw 19\nSkipping line 1554: expected 9 fields, saw 19\nSkipping line 1558: expected 9 fields, saw 12\nSkipping line 1559: expected 9 fields, saw 12\nSkipping line 1562: expected 9 fields, saw 13\nSkipping line 1563: expected 9 fields, saw 12\nSkipping line 1564: expected 9 fields, saw 13\nSkipping line 1565: expected 9 fields, saw 12\nSkipping line 1566: expected 9 fields, saw 10\nSkipping line 1569: expected 9 fields, saw 20\nSkipping line 1570: expected 9 fields, saw 13\nSkipping line 1571: expected 9 fields, saw 21\nSkipping line 1572: expected 9 fields, saw 10\nSkipping line 1573: expected 9 fields, saw 10\nSkipping line 1574: expected 9 fields, saw 13\nSkipping line 1575: expected 9 fields, saw 14\nSkipping line 1576: expected 9 fields, saw 15\nSkipping line 1577: expected 9 fields, saw 16\nSkipping line 1578: expected 9 fields, saw 11\nSkipping line 1580: expected 9 fields, saw 10\nSkipping line 1582: expected 9 fields, saw 10\nSkipping line 1584: expected 9 fields, saw 24\nSkipping line 1585: expected 9 fields, saw 10\nSkipping line 1586: expected 9 fields, saw 23\nSkipping line 1587: expected 9 fields, saw 13\nSkipping line 1590: expected 9 fields, saw 23\nSkipping line 1592: expected 9 fields, saw 14\nSkipping line 1594: expected 9 fields, saw 11\nSkipping line 1595: expected 9 fields, saw 18\nSkipping line 1602: expected 9 fields, saw 10\nSkipping line 1603: expected 9 fields, saw 11\nSkipping line 1607: expected 9 fields, saw 11\nSkipping line 1608: expected 9 fields, saw 14\nSkipping line 1609: expected 9 fields, saw 11\nSkipping line 1610: expected 9 fields, saw 10\nSkipping line 1611: expected 9 fields, saw 22\nSkipping line 1613: expected 9 fields, saw 12\nSkipping line 1616: expected 9 fields, saw 10\nSkipping line 1617: expected 9 fields, saw 12\nSkipping line 1623: expected 9 fields, saw 11\nSkipping line 1624: expected 9 fields, saw 11\nSkipping line 1625: expected 9 fields, saw 14\nSkipping line 1626: expected 9 fields, saw 14\nSkipping line 1628: expected 9 fields, saw 26\nSkipping line 1630: expected 9 fields, saw 18\nSkipping line 1631: expected 9 fields, saw 12\nSkipping line 1632: expected 9 fields, saw 11\nSkipping line 1633: expected 9 fields, saw 11\nSkipping line 1635: expected 9 fields, saw 11\nSkipping line 1637: expected 9 fields, saw 12\nSkipping line 1638: expected 9 fields, saw 12\nSkipping line 1639: expected 9 fields, saw 12\nSkipping line 1641: expected 9 fields, saw 10\nSkipping line 1642: expected 9 fields, saw 20\nSkipping line 1643: expected 9 fields, saw 19\nSkipping line 1644: expected 9 fields, saw 13\nSkipping line 1645: expected 9 fields, saw 24\nSkipping line 1647: expected 9 fields, saw 12\nSkipping line 1649: expected 9 fields, saw 24\nSkipping line 1650: expected 9 fields, saw 12\nSkipping line 1652: expected 9 fields, saw 19\nSkipping line 1653: expected 9 fields, saw 12\nSkipping line 1654: expected 9 fields, saw 11\nSkipping line 1655: expected 9 fields, saw 12\nSkipping line 1656: expected 9 fields, saw 18\nSkipping line 1657: expected 9 fields, saw 13\nSkipping line 1658: expected 9 fields, saw 15\nSkipping line 1663: expected 9 fields, saw 23\nSkipping line 1665: expected 9 fields, saw 10\nSkipping line 1666: expected 9 fields, saw 25\nSkipping line 1667: expected 9 fields, saw 12\nSkipping line 1668: expected 9 fields, saw 10\nSkipping line 1672: expected 9 fields, saw 15\nSkipping line 1675: expected 9 fields, saw 10\nSkipping line 1677: expected 9 fields, saw 13\nSkipping line 1678: expected 9 fields, saw 12\nSkipping line 1679: expected 9 fields, saw 10\nSkipping line 1680: expected 9 fields, saw 10\nSkipping line 1681: expected 9 fields, saw 12\nSkipping line 1683: expected 9 fields, saw 13\nSkipping line 1685: expected 9 fields, saw 10\nSkipping line 1686: expected 9 fields, saw 14\nSkipping line 1687: expected 9 fields, saw 13\nSkipping line 1688: expected 9 fields, saw 19\nSkipping line 1691: expected 9 fields, saw 11\nSkipping line 1692: expected 9 fields, saw 11\nSkipping line 1693: expected 9 fields, saw 10\nSkipping line 1694: expected 9 fields, saw 16\nSkipping line 1695: expected 9 fields, saw 10\nSkipping line 1696: expected 9 fields, saw 11\nSkipping line 1697: expected 9 fields, saw 23\nSkipping line 1698: expected 9 fields, saw 12\nSkipping line 1699: expected 9 fields, saw 10\nSkipping line 1700: expected 9 fields, saw 10\nSkipping line 1701: expected 9 fields, saw 10\nSkipping line 1702: expected 9 fields, saw 10\nSkipping line 1704: expected 9 fields, saw 20\nSkipping line 1706: expected 9 fields, saw 13\nSkipping line 1708: expected 9 fields, saw 10\nSkipping line 1710: expected 9 fields, saw 13\nSkipping line 1711: expected 9 fields, saw 16\nSkipping line 1713: expected 9 fields, saw 21\nSkipping line 1714: expected 9 fields, saw 10\nSkipping line 1715: expected 9 fields, saw 11\nSkipping line 1717: expected 9 fields, saw 10\nSkipping line 1719: expected 9 fields, saw 13\nSkipping line 1721: expected 9 fields, saw 11\nSkipping line 1722: expected 9 fields, saw 16\nSkipping line 1723: expected 9 fields, saw 11\nSkipping line 1726: expected 9 fields, saw 10\nSkipping line 1727: expected 9 fields, saw 18\nSkipping line 1728: expected 9 fields, saw 23\nSkipping line 1731: expected 9 fields, saw 14\nSkipping line 1734: expected 9 fields, saw 14\nSkipping line 1738: expected 9 fields, saw 11\nSkipping line 1739: expected 9 fields, saw 10\nSkipping line 1741: expected 9 fields, saw 23\nSkipping line 1743: expected 9 fields, saw 17\nSkipping line 1744: expected 9 fields, saw 12\nSkipping line 1745: expected 9 fields, saw 10\nSkipping line 1748: expected 9 fields, saw 22\nSkipping line 1749: expected 9 fields, saw 11\nSkipping line 1750: expected 9 fields, saw 13\nSkipping line 1752: expected 9 fields, saw 10\nSkipping line 1753: expected 9 fields, saw 11\nSkipping line 1755: expected 9 fields, saw 18\nSkipping line 1756: expected 9 fields, saw 16\nSkipping line 1757: expected 9 fields, saw 11\nSkipping line 1759: expected 9 fields, saw 16\nSkipping line 1761: expected 9 fields, saw 49\nSkipping line 1762: expected 9 fields, saw 24\nSkipping line 1765: expected 9 fields, saw 10\nSkipping line 1766: expected 9 fields, saw 11\nSkipping line 1768: expected 9 fields, saw 21\nSkipping line 1769: expected 9 fields, saw 13\nSkipping line 1772: expected 9 fields, saw 21\nSkipping line 1774: expected 9 fields, saw 18\nSkipping line 1775: expected 9 fields, saw 10\nSkipping line 1777: expected 9 fields, saw 24\nSkipping line 1778: expected 9 fields, saw 14\nSkipping line 1779: expected 9 fields, saw 16\nSkipping line 1780: expected 9 fields, saw 11\nSkipping line 1781: expected 9 fields, saw 10\nSkipping line 1782: expected 9 fields, saw 19\nSkipping line 1783: expected 9 fields, saw 11\nSkipping line 1786: expected 9 fields, saw 11\nSkipping line 1787: expected 9 fields, saw 24\nSkipping line 1790: expected 9 fields, saw 26\nSkipping line 1794: expected 9 fields, saw 12\nSkipping line 1795: expected 9 fields, saw 10\nSkipping line 1796: expected 9 fields, saw 11\n' Traceback (most recent call last): File "D:/Clustering/text-cluster-master/similarity.py", line 58, in <module> X = pd.read_csv(r"D:\Clustering\text-cluster-master\text-cluster-master\Articles.csv", index_col='id', error_bad_lines=False) File "D:\Python3.8.0\Python\lib\site-packages\pandas\io\parsers.py", line 605, in read_csv return _read(filepath_or_buffer, kwds) File "D:\Python3.8.0\Python\lib\site-packages\pandas\io\parsers.py", line 463, in _read return parser.read(nrows) File "D:\Python3.8.0\Python\lib\site-packages\pandas\io\parsers.py", line 1052, in read index, columns, col_dict = self._engine.read(nrows) File "D:\Python3.8.0\Python\lib\site-packages\pandas\io\parsers.py", line 2096, in read values = data.pop(self.index_col[i]) KeyError: 'id'
Reply
#7
Please show the first 10 lines of your XML file.
Reply
#8
@ibreeden yeah first 10 lines of CSV files are that i have highlight number from (1).....(11)
  1. 1)id,summary,column_name,title,cover,published_at,extraction_tags,favourite_num
    2)5161617, this report will become the basis for the government to further formulate laws and regulations. , Blockchain, of

Reply
#9
Hi Anldra, you will never be able to read this CSV file because it is not valid CSV. The field separator is apparently a comma, but it contains unquoted text that also contains comma's. So it is impossible for a program to determine which comma's are field separator and which are just comma's in the text.
As an example I look at the second field (name: "column_name") in line 4.
Output:
Judging from the application of Planet and SPIRE to rockets, they are definitely the users who have the right to say "right" in the circle.
In a valid CSV file this should be:
Output:
"Judging from the application of Planet and SPIRE to rockets, they are definitely the users who have the right to say ""right"" in the circle."
So this field should be enclosed in quotes and quotes inside the field must be doubled.

So please make sure you get a valid CSV file.
Reply
#10
@ibreeden yeah that the reason that makes me worried so i need to change the CSV files data.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Better python library to create ER Diagram by using pandas data frames as tables klllmmm 0 987 Oct-19-2023, 01:01 PM
Last Post: klllmmm
  Using pyodbc&pandas to load a Table data to df tester_V 3 746 Sep-09-2023, 08:55 PM
Last Post: tester_V
  Likert survey data plot error Andrzej_Andrzej 6 1,305 Jul-16-2023, 10:11 PM
Last Post: deanhystad
  pyarrow error when importing pandas sravva 1 884 Jun-06-2023, 05:09 PM
Last Post: snippsat
  File "<string>", line 19, in <module> error is related to what? Frankduc 9 12,391 Mar-09-2023, 07:22 AM
Last Post: LocklearSusan
  Read nested data from JSON - Getting an error marlonbown 5 1,309 Nov-23-2022, 03:51 PM
Last Post: snippsat
  Plotly send pandas.errors.UndefinedVariableError. Frankduc 3 1,350 Oct-27-2022, 02:26 PM
Last Post: deanhystad
  Pandas - error when running Pycharm, but works on cmd line zxcv101 1 1,321 Jun-18-2022, 01:09 PM
Last Post: snippsat
  Compare fields from two csv files georgebijum 3 1,335 Apr-25-2022, 11:16 PM
Last Post: Pedroski55
  Move a particular row in pandas data frame to last row klllmmm 0 3,644 Dec-27-2021, 09:11 AM
Last Post: klllmmm

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020