Filter specific Values from a csv file

Question

I would like to build a python3 script that will download a CSV file every day and send it to me by mail. I have managed to download the file and sending the mail. The problem is the filtering. The CSV file contains

"155;03155;Northeim;1669;1261.7;9;35;0;131.55;66;49.9"

and I want to filter only the last value 49.9 and send it to me by mail. This Value changes daily. But the order of the values doesn't.

Can someone help me?

I'd just use csv.reader - docs.python.org/3/library/csv.html - set your delimiter to ";", and take field [10] — michjnich
– michjnich, Commented Mar 22, 2021 at 11:28

Vishal Singh · Accepted Answer · 2021-03-22 11:48:52Z

1

If your CSV file only contains 1 row then read the file, split at ; and access the last element of the list using [-1].

with open('your_csv_file.csv') as fp:
    value = fp.read().split(';')[-1]

answered Mar 22, 2021 at 11:48

Vishal Singh

6,2522 gold badges19 silver badges34 bronze badges

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

1 Comment

fckilagged Over a year ago

thank you very much, it worked perfectly :)

Collectives™ on Stack Overflow

Filter specific Values from a csv file

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