How to quickly get the last line from a .csv file over a network drive?
16,565
There is a nifty reversed
tool for this, assuming you are using the built-in csv
module:
how to read a csv file in reverse order in python
In short:
import csv
with open('some_file.csv', 'r') as f:
for row in reversed(list(csv.reader(f))):
print(', '.join(row))
In my test file of:
1: test, 1
2: test, 2
3: test, 3
This outputs:
test, 3
test, 2
test, 1
Author by
user1367204
Updated on June 09, 2022Comments
-
user1367204 almost 2 years
I store thousands of time series in
.csv
files on a network drive. Before I update the files, I first get the last line of the file to see the timestamp and then I update with data after that timestamp. How can I quickly get the last line of a.csv
file over a network drive so that I don't have to load the entire huge.csv
file only to use the last line? -
user1367204 almost 7 yearsI feel like this still will read the entire file into memory, while what I need is just to read the last row into memory so that it doesn't waste time reading unnecessary stuff into memory.
-
Douglas almost 7 yearsYou could try being more explicit, without iterating over each row by indexing:
print(', '.join(reversed(list(csv.reader(f))[-1])))
I am sure there is a better way to do it, but that is what comes to mind... -
user1367204 almost 7 yearsI just tested that and it was the same amount of time =(
-
Douglas almost 7 yearsThere was another thread you may want to check out... haven't tried it, but it might be worth while... uses
seek
: stackoverflow.com/questions/260273/…