Hallo kann mir jemand sagen was an diesem Script falsch ist, das ich nachdem ich die beiden Variabeln start und end eingegeben habe diese Fehlermeldung bekomme?
Code: Alles auswählen
from datetime import time
from io import StringIO
import pandas as pd
import csv
with open('test.csv') as lines:
reader = csv.reader(lines, delimiter=',')
tabelle = [
row[:1] + [float(c) for c in row[1:]]
for row in reader
]
def select_by_time(csv, start, end):
df = pd.read_csv(StringIO(csv), header=None, index_col=0, parse_dates=True)
return df[time(*start):time(*end)]
def main():
time = [zeile[0] for zeile in tabelle ]
str_tabelle = " ".join(time)
start = int(input("Ihre Eingabe start? "))
end = int(input("Ihre Eingabe end? "))
result = select_by_time(str_tabelle, (start, 0), (end, 0))
print(result)
if __name__ == '__main__':
main()
Code: Alles auswählen
Ihre Eingabe start? 15
Ihre Eingabe end? 17
Traceback (most recent call last):
File "D:\Programmieren\Python\lib\site-packages\pandas\core\indexes\base.py", line 3078, in get_loc
return self._engine.get_loc(key)
File "pandas\_libs\index.pyx", line 140, in pandas._libs.index.IndexEngine.get_loc
File "pandas\_libs\index.pyx", line 162, in pandas._libs.index.IndexEngine.get_loc
File "pandas\_libs\hashtable_class_helper.pxi", line 1492, in pandas._libs.hashtable.PyObjectHashTable.get_item
File "pandas\_libs\hashtable_class_helper.pxi", line 1500, in pandas._libs.hashtable.PyObjectHashTable.get_item
KeyError: datetime.time(15, 0)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "D:\Programmieren\Python\lib\site-packages\pandas\core\indexes\base.py", line 4238, in get_slice_bound
slc = self._get_loc_only_exact_matches(label)
File "D:\Programmieren\Python\lib\site-packages\pandas\core\indexes\base.py", line 4207, in _get_loc_only_exact_matches
return self.get_loc(key)
File "D:\Programmieren\Python\lib\site-packages\pandas\core\indexes\base.py", line 3080, in get_loc
return self._engine.get_loc(self._maybe_cast_indexer(key))
File "pandas\_libs\index.pyx", line 140, in pandas._libs.index.IndexEngine.get_loc
File "pandas\_libs\index.pyx", line 162, in pandas._libs.index.IndexEngine.get_loc
File "pandas\_libs\hashtable_class_helper.pxi", line 1492, in pandas._libs.hashtable.PyObjectHashTable.get_item
File "pandas\_libs\hashtable_class_helper.pxi", line 1500, in pandas._libs.hashtable.PyObjectHashTable.get_item
KeyError: datetime.time(15, 0)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "D:/Programmieren/Python/Dateien/Csv Lesen/Eingabe_1.py", line 27, in <module>
main()
File "D:/Programmieren/Python/Dateien/Csv Lesen/Eingabe_1.py", line 23, in main
result = select_by_time(str_tabelle, (start, 0), (end, 0))
File "D:/Programmieren/Python/Dateien/Csv Lesen/Eingabe_1.py", line 15, in select_by_time
return df[time(*start):time(*end)]
File "D:\Programmieren\Python\lib\site-packages\pandas\core\frame.py", line 2676, in __getitem__
indexer = convert_to_index_sliceable(self, key)
File "D:\Programmieren\Python\lib\site-packages\pandas\core\indexing.py", line 2326, in convert_to_index_sliceable
return idx._convert_slice_indexer(key, kind='getitem')
File "D:\Programmieren\Python\lib\site-packages\pandas\core\indexes\base.py", line 1751, in _convert_slice_indexer
indexer = self.slice_indexer(start, stop, step, kind=kind)
File "D:\Programmieren\Python\lib\site-packages\pandas\core\indexes\base.py", line 4107, in slice_indexer
kind=kind)
File "D:\Programmieren\Python\lib\site-packages\pandas\core\indexes\base.py", line 4308, in slice_locs
start_slice = self.get_slice_bound(start, 'left', kind)
File "D:\Programmieren\Python\lib\site-packages\pandas\core\indexes\base.py", line 4241, in get_slice_bound
return self._searchsorted_monotonic(label, side)
File "D:\Programmieren\Python\lib\site-packages\pandas\core\indexes\base.py", line 4191, in _searchsorted_monotonic
return self.searchsorted(label, side=side)
File "D:\Programmieren\Python\lib\site-packages\pandas\util\_decorators.py", line 178, in wrapper
return func(*args, **kwargs)
File "D:\Programmieren\Python\lib\site-packages\pandas\core\base.py", line 1230, in searchsorted
return self.values.searchsorted(value, side=side, sorter=sorter)
TypeError: '<' not supported between instances of 'str' and 'datetime.time'