insert data in rows based on conditional value in python

Question

I have a log file (.txt) containing the following data structure:

ID-Number 1

value 1

value 2

ID-Number 2

value 1

value 2

value 3

ID-Number 3

value 1

I'm expecting to have the following every ID-Number could have multiple values. I need to put each value beside it's ID-Number like the following:

ID-Number 1,value 1,value 2

ID-Number 2,value 1,value 2,value 3

ID-Number 3,value 1

do you have id number or how you differentiate id number with value? — galaxyan
– galaxyan, Commented Jun 17, 2019 at 22:26
the string 'ID-Number' is static in each 'ID-Number <int>' field. the integer number is the one that changed every time. — ME_sociaty
– ME_sociaty, Commented Jun 17, 2019 at 22:29
Why the pandas tag? Do you need a pandas dataframe out of this file? — Valentino
– Valentino, Commented Jun 17, 2019 at 22:47
My goal is to store the final output into CSV or excel format. hence, I added pandas perhaps i will use one of pandas functions to store my data on df and then organize it as per the above structure — ME_sociaty
– ME_sociaty, Commented Jun 17, 2019 at 22:59

galaxyan · Accepted Answer · 2019-06-17 23:31:12Z

1

with open(filename, 'r') as f:
    newline = []
    res = []
    for line in f:
        line = line.strip()
        if 'ID-Number' in line:
            if newline:
                res.append(','.join(newline))
            newline = [line]
            continue
        newline.append(line)
res.append(','.join(newline))

edited Jun 17, 2019 at 23:31

answered Jun 17, 2019 at 22:33

galaxyan

6,1593 gold badges23 silver badges44 bronze badges

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

1 Comment

ME_sociaty Over a year ago

removing res.append(','.join(newline)) worked for me thank you @galaxyan

Collectives™ on Stack Overflow

insert data in rows based on conditional value in python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related