An example of a Line in my text file: Hellothisismyquestion56464
I want to my Data frame to look like this:
| C1 | C2 | C3 | C4 | C5 | C6 |
|---|---|---|---|---|---|
| Hello | this | is | my | question | 56464 |
Asked
Active
Viewed 1,260 times
-1
-
`pandas.read_fwf` – Paul H Apr 18 '22 at 17:30
-
How will you decide where to divide those words? Are they separated at all? – Tim Roberts Apr 18 '22 at 17:33
-
Here's an attempt to solve your issue https://stackoverflow.com/questions/8870261/how-to-split-text-without-spaces-into-list-of-words/11642687#11642687 – Daniel Weigel Apr 18 '22 at 17:45
-
Please provide enough code so others can better understand or reproduce the problem. – Community Apr 19 '22 at 03:58
1 Answers
1
There are a variety of methods available to read a text file using pandas as mentioned here.
However, you need to specify a delimiter or a separator to achieve what you are trying to do. Following is an example code snippet of the same:
import pandas as pd
# read text file into pandas DataFrame and create header with names
df = pd.read_csv("gfg.txt", sep=" ", header=None,
names=["Team1", "Team2"])
# display DataFrame
print(df)
Saksham Gupta
- 38
- 5
-
Please include a code example in your answer. While links are useful, a good answer has enough text in it to "stand on its own". – ToolmakerSteve Apr 19 '22 at 00:00
-