Pandas Expected 10 Fields In Line 153, Saw 11,how To Add One More Column

I have a info.txt file it looks like this: B 19960331 00100000 00000000000000 00000000000000 00000000000000 00000000 00000000000000 00000000000000 00000000000000 B 19960430 0009910

Solution 1:

This works, might fit your needs:

df = pd.read_csv(... names=range(11))

Solution 2:

You can use the error_bad_lines argument to avoid this error.

import pandas as pd
import numpy as np
df = pd.read_csv("C:\Users\Petter\Desktop\info.txt", header=None, delimiter=r"\s+", error_bad_lines=False)
df