regex results from a csv to a csv output

Question

I would like to save my results in my csv. But somehow it remains empty. But if I write the same output not in the csv and only print I get my results As I would like it to have.

import re
import glob
import os
## is the second script for matchParser.py, match the results for Duration in ms digit
lines = [line.strip() for line in open('output.csv')]
for result in lines:

    match = re.search(r'(!?\s.\d[Request completed in\s])', result)
    if match: print match.group(0)

but this version with the output_csv is not working, i dont know why..

import re
import glob
import os

lines = [line.strip() for line in open('output.csv')]
for result in lines:

    match = re.search(r'(!?\s.\d[Request completed in\s])', result)
    with open('outputREGEX5.csv', "w") as output_csv:
        if match: output_csv.write(match.group(0))

I also get the following error:

output.write(match.group(0))
AttributeError: 'NoneType' object has no attribute 'group'

Am grateful for any help.

-- EDIT My print Output:

Alex Hall · Accepted Answer · 2016-12-16 15:07:57Z

4

open('outputREGEX5.csv', "w")

empties the file. Only open the file once outside of the loop, instead of opening it every iteration.

with open('outputREGEX5.csv', "w") as output_csv:
    for result in lines:
        match = re.search(r'(!?\s.\d[Request completed in\s])', result)
        if match: output_csv.write(match.group(0) + '\n')

edited Dec 16, 2016 at 15:07

answered Dec 16, 2016 at 14:38

Alex Hall

36.2k5 gold badges63 silver badges98 bronze badges

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

6 Comments

madik_atma Over a year ago

Can you please explain it a bit more precisely and say exactly where I should place it? I am a newbie in python

glibdud Over a year ago

Almost... the match = ... line should be before the if match:, and at the same indent level.

madik_atma Over a year ago

its working! but the entrys are not in newline as in the print version. how can I add a \n So that every iteration is written into a new line?

Alex Hall Over a year ago

@harun literally just by adding a \n to the thing that you're writing. Come on, give it a try.

madik_atma Over a year ago

I tried. Unfortunately without success. Always get this error: NameError: name 'match' is not defined :/

|

Collectives™ on Stack Overflow

regex results from a csv to a csv output

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related