Python Forum
Reading specific rows (lookup)
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Reading specific rows (lookup)
#4
import csv

def main():
    year = "2018"
    week = "01"
    results = []
    with open("./files/sample.csv", "r") as fh:
        reader = csv.reader(fh, delimiter=',')
        for row in reader:
            row = list(map(str.strip, row))
            if row[0] == year and row[1] == week:
                results.append((row[2] + ":" + row[3], row[4]))
    print(results)


if __name__ == "__main__":
    main()
Something like this
Reply


Messages In This Thread
Reading specific rows (lookup) - by rumbles - Jan-03-2018, 12:01 PM
RE: Reading specific rows (lookup) - by hshivaraj - Jan-03-2018, 01:28 PM
RE: Reading specific rows (lookup) - by rumbles - Jan-03-2018, 03:25 PM
RE: Reading specific rows (lookup) - by hshivaraj - Jan-03-2018, 04:07 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Reading Specific Rows In a CSV File finndude 3 1,005 Dec-13-2022, 03:19 PM
Last Post: finndude
  reading content between a specific xml tag saisankalpj 1 854 Oct-31-2022, 01:37 PM
Last Post: wavic
  Pymysql delete specific rows in tableview stsxbel 2 1,098 Aug-18-2022, 09:50 AM
Last Post: ibreeden
  Trying to delete rows above a specific datetime value cubangt 19 11,566 May-09-2022, 08:57 PM
Last Post: deanhystad
  2-dataframe, datetime lookup problem Mark17 0 1,244 Jan-27-2022, 01:02 AM
Last Post: Mark17
  The code I have written removes the desired number of rows, but wrong rows Jdesi1983 0 1,638 Dec-08-2021, 04:42 AM
Last Post: Jdesi1983
  Python VLookup? Lookup Table? Nu2Python 3 2,439 Oct-25-2021, 08:47 PM
Last Post: Nu2Python
  Pandas DataFrame combine rows by column value, where Date Rows are NULL rhat398 0 2,127 May-04-2021, 10:51 PM
Last Post: rhat398
  Can I replace IF statements with a key lookup ? jehoshua 3 2,537 Mar-05-2021, 10:24 PM
Last Post: jehoshua
  Indexing [::-1] to Reverse ALL 2D Array Rows, ALL 3D, 4D Array Columns & Rows Python Jeremy7 8 7,168 Mar-02-2021, 01:54 AM
Last Post: Jeremy7

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020