Как прочитать файл csv с определенными строками с помощью python

У меня есть данные в формате csv, и я хочу прочитать данные, начиная с "Date","Time","Stream 1","Stream 2","Stream 3","Stream 4","Stream 5","Stream 6","Stream 7".

Data Record,,,,
Radio Model,HE910-D,,,
IMEI Number,32161331,,,
Sim Number,9181283211,,,
Signal Level,12,,,
Bit Error Rate,3,,,
Supply Voltage,12.1,,,
Latitude,5123.2N,,,
Longitude,6123.2W,,,
,,,,
,,,,
,,,,
,,,,
,,,,
,,,,
,,,,
,,,,
,,,,
,,,,
,,,,
,,,,
,,,,
,,,,
"Date","Time","Stream 1","Stream 2","Stream 3","Stream 4","Stream 5","Stream 6","Stream 7"
"2022-08-22","17:15:00","14","1","11","14","1","14","1"
"2022-08-22","15:15:00","36","5","12","36","5","36","5"
"2022-08-22","13:15:00","48","9","13","48","9","48","9"
"2022-08-22","11:15:00","15","0","14","15","0","15","0"
"2022-08-22","17:15:00","7","8","15","7","8","7","8"
"2022-08-22","15:15:00","70","7","16","70","7","70","7"
"2022-08-22","13:15:00","95","5","27","95","5","95","5"
"2022-08-22","11:15:00","23","4","38","23","4","23","4"
"2022-08-22","11:15:00","67","3","49","67","3","67","3"
"2022-08-22","11:15:00","23","1","21","23","1","23","1"
"2022-08-22","11:15:00","12","2","23","12","2","12","2"
"2022-08-22","17:15:00","34","21","22","34","21","34","21"
"2022-08-22","15:15:00","23","34","23","23","34","23","34"
"2022-08-22","13:15:00","14","23","45","14","23","14","23"
"2022-08-22","11:15:00","23","21","43","23","21","23","21"

Я также пытался использовать этот код, но он выводит все данные. Возможно ли получить только строки, которые начинаются с ``Дата'', ``Время'', ``Поток 1'', ``Поток 2'', ``Поток 3'', ``Поток 4'', ``Поток 5'', ``Поток 6'', ``Поток 7'' 

    with open(path + "Book1.csv", "r") as file:
        reader = csv.DictReader(file, delimiter=';')
        for l in reader:
            print(l)

мой желаемый результат

"Date","Time","Stream 1","Stream 2","Stream 3","Stream 4","Stream 5","Stream 6","Stream 7"
    "2022-08-22","17:15:00","14","1","11","14","1","14","1"
    "2022-08-22","15:15:00","36","5","12","36","5","36","5"
    "2022-08-22","13:15:00","48","9","13","48","9","48","9"
    "2022-08-22","11:15:00","15","0","14","15","0","15","0"
    "2022-08-22","17:15:00","7","8","15","7","8","7","8"
    "2022-08-22","15:15:00","70","7","16","70","7","70","7"
    "2022-08-22","13:15:00","95","5","27","95","5","95","5"
    "2022-08-22","11:15:00","23","4","38","23","4","23","4"
    "2022-08-22","11:15:00","67","3","49","67","3","67","3"
    "2022-08-22","11:15:00","23","1","21","23","1","23","1"
    "2022-08-22","11:15:00","12","2","23","12","2","12","2"
    "2022-08-22","17:15:00","34","21","22","34","21","34","21"
    "2022-08-22","15:15:00","23","34","23","23","34","23","34"
    "2022-08-22","13:15:00","14","23","45","14","23","14","23"
    "2022-08-22","11:15:00","23","21","43","23","21","23","21"

Вы просто печатаете первую строку, набирая print(l[0]), чтобы получить заголовки, вместо того, чтобы использовать цикл for.

Если вам нужно использовать дополнительную библиотеку с именем pandas, попробуйте следующее:

import pandas as pd

req_cols = ["Date","Time","Stream 1","Stream 2","Stream 3","Stream 4","Stream 5","Stream 6","Stream 7"]
df = pd.read_csv('Book1.csv', sep=';', usecols=req_cols)
print(df)
Вернуться на верх