Python CSV (oldschool)

Asked Oct 22 '20 at 19:52

Active Oct 22 '20 at 19:52

Viewed 22 times

I got a problem with reading csv. I can't use panda or other libraries so I coded this piece.

def read_csv(path):
    
    with open(path, 'r') as f:
        results = []
        newresults= []
        for line in f:
            words = line.split(',')
            print(words)
            for i in words:
                if i[-1:] == '\n':
                    i[-1:] = ""

            results.append(words)

        for lines in results:
            if lines == []:
                results.remove(lines)

        for a in results:
            newresults.append(tuple(a))
            
        return newresults

I can't get to remove those \n at the end of every List within the main list.

[('Age', 'Gender', 'Weight (kg)', 'Height (cm)\n'), ('28', 'Female', '58', '168\n'), ('33', 'Male', '', '188\n')]

and my code above with

            for i in words:
                if i[-1:] == '\n':
                    i[-1:] = ""

doesn't work...

Thanks in advance

asked Oct 22 '20 at 19:52

Orsons

4

`words = line.rstrip().split(',')` – Olvin Roght Oct 22 '20 at 19:53
Python strings are immutable. You cannot change them. – DYZ Oct 22 '20 at 19:54
can you can use `csv` module, part of standard library? – buran Oct 22 '20 at 19:55
`return [stripped.split(',') for stripped in (line.strip() for line in f) if stripped]` – tdelaney Oct 22 '20 at 20:04
@tdelaney, I would use `f.readlines()` for one-liner, cause it returns already "stripped" lines. – Olvin Roght Oct 22 '20 at 20:38
thank you guys!! rstrip is exactly what i was searching for – Orsons Oct 22 '20 at 21:01
@OlvinRoght - No, it returns the same line endings as iteration. If you did `open(...).read().split("\n")` you'd get rid of the newlines, but `readlines` doesn't. – tdelaney Oct 22 '20 at 21:11

Python CSV (oldschool)

0 Answers0