Das deutsche Python-Forum

Code: Alles auswählen

import os
import csv

with open("/home/****/******/*****.csv","r") as csv_datei:
    reader = csv.reader(csv_datei, delimiter=';')

    for zeile in reader:
        print(zeile[3])

Code: Alles auswählen

#!/usr/bin/env python3
import csv
from datetime import datetime as DateTime
from itertools import groupby
from operator import itemgetter


def main():
    with open(
        "/home/****/******/*****.csv", "r", newline="", encoding="utf-8"
    ) as csv_file:
        print(
            [
                (
                    #
                    # TODO: Eventuell muss man hier das Datumsformat anpassen,
                    #   da aus dem Beispiel nicht klar wird in welcher
                    #   Reihenfolge Tag und Monat in der Datei angegeben sind.
                    #
                    DateTime.strptime(date_text, "%d.%m.%Y").date(),
                    max(float(row[2]) for row in group),
                )
                for date_text, group in groupby(
                    csv.reader(csv_file, delimiter=";"), itemgetter(0)
                )
            ]
        )


if __name__ == "__main__":
    main()

Code: Alles auswählen

def main():
    with open(
        "/home/bunjul/Schreibtisch/Lösch.csv", "r", newline="", encoding="utf-8"
    ) as csv_file:
    
    read = csv.reader(csv_file)
    for line in read:
        print(line)
    
       
    
        print(
            [
                (
                    #
                    # TODO: Eventuell muss man hier das Datumsformat anpassen,
                    #   da aus dem Beispiel nicht klar wird in welcher
                    #   Reihenfolge Tag und Monat in der Datei angegeben sind.
                    #
                    DateTime.strptime(date_text, "%d.%m.%Y").date(),
                    max(float(row[1]) for row in group),
                )

                for date_text, group in groupby(
                    csv.reader(csv_file, delimiter=";"), itemgetter(0)
                )
            ]
        )


if __name__ == "__main__":
    main()

Code: Alles auswählen

#!/usr/bin/env python3
import csv
from collections import namedtuple
from datetime import datetime as DateTime
from itertools import groupby
from operator import attrgetter


class Record(namedtuple("_Record", "timestamp temperature")):

    @property
    def date(self):
        return self.timestamp.date()

    @classmethod
    def from_row(cls, row):
        return cls(
            DateTime.strptime(row[0], "%d.%m.%Y %H:%M"),
            float(row[1].replace(",", ".")),
        )


def main():
    with open(
        "/home/bunjul/Schreibtisch/Lösch.csv", newline="", encoding="utf-8"
    ) as csv_file:
        rows = csv.reader(csv_file, delimiter=";")
        print(next(rows))  # Skip and print header.
        records = map(Record.from_row, rows)
        daily_max_temperatures = (
            max(group, key=attrgetter("temperature"))
            for _, group in groupby(records, attrgetter("date"))
        )
        print(list(daily_max_temperatures))


if __name__ == "__main__":
    main()

Code: Alles auswählen

import csv
from collections import namedtuple
from datetime import datetime as DateTime
from itertools import groupby
from operator import attrgetter


class Record(namedtuple("_Record", "timestamp temperature")):

    @property
    def date(self):
        return self.timestamp.date()

    @classmethod
    def from_row(cls, row):
        return cls(
            DateTime.strptime(row[0], "%d.%m.%Y %H:%M"),
            float(row[1].replace(",", "." )),

        )


def main():
    with open(
        "/home/bunjul/Schreibtisch/Lösch.csv", newline="", encoding="utf-8"
    ) as csv_file:
        rows = csv.reader(csv_file, delimiter=";")
        print(next(rows))  # Skip and print header.
        records = map(Record.from_row, rows)
        daily_max_temperatures = (
            max(group, key=attrgetter("temperature"))
            for _, group in groupby(records, attrgetter("date"))
        )
        

        x =  (list(daily_max_temperatures))
        for l in x:

            print(l)
            




if __name__ == "__main__":
    main()

Code: Alles auswählen

for daily_max_temperature in daily_max_temperatures:
    print(f"{daily_max_temperature.timestamp:%d.%m.%Y %H:%M}, {daily_max_temperature.temperature:.1f}")