I'm having a file containing a row having actually many columns separated by space, but panda is reading them as one column.
For more detail I've attached here the part of the file. Any type of suggetion/discussion will be welcomed. TIA -Shruti
I've tried to separate them using str.split() & str.extract(), but didn't work. I want to split (so called single) column into multiple columns containg a data separated by space in (single) previous column.
INPUT FILE: enter image description here
| Column A | Column B |
| --------------| -------- |
|1 1 1 1 1 1 1 1| |
|1 1 1 1 1 1 1 1| |
EXPECTED : enter image description here
| Column A | Column B |Column C |.......
| ---------| -------- | --------|
| 1 | 1 | 1 |.......
| 1 | 1 | 1 |.......