How to skip rows from a file until a specific string without using any input code?

Question

I have a txt file name 'test.txt' and want to skip the first rows until I get to the line with the string "~A".

At this line, I want to remove "~A" and create a dataframe with 3 columns named 'Stats1', 'Stats2' and 'Stats3' and the related values below.

Also, I do not want to use any 'input' function to skip rows while opening the file as I would like to generalize this to other files.

Here is how the file looks like:

Text 1

Text 2

Text 3

Text 4

~A Stats1 Stats2 Stats3

1 2 3

6 6 7

8 9 3

Thank you!

Yevhen Kuzmovych · Accepted Answer · 2019-08-29 15:07:02Z

2

That should work:

with open('test.txt') as f:
    for l in f:
        if l.startswith('~A'):
            columns = l.split()[1:]
            break
    df = pd.read_csv(f, names=columns, sep=' ')

By looping through file f you consume unneeded lines.

Output:

>>> df
   Stats1  Stats2  Stats3
0       1       2       3
1       6       6       7
2       8       9       3

answered Aug 29, 2019 at 15:07

Yevhen Kuzmovych

12.3k8 gold badges32 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user026 Over a year ago

That is it, @Yevhen! That worked perfectly for me. Thanks a lot

anky Over a year ago

@LucasA please consider accepting the answer by checking the tick mark to the left of the answer

Collectives™ on Stack Overflow

How to skip rows from a file until a specific string without using any input code?

Text 1

Text 2

Text 3

Text 4

~A Stats1 Stats2 Stats3

1 2 3

6 6 7

8 9 3

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Text 1

Text 2

Text 3

Text 4

~A Stats1 Stats2 Stats3

1 2 3

6 6 7

8 9 3

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related