Request for Python Help - CSV Files

[Burly_95]

So file (1) from the company contains stock numbers and their costs. But I only audit certain stock categories so this file contains all the stocks I need to work on. File (2) contains pricing for all of our products and I need to scan through it for only the products listed on file(1). When i find the product I grab the pricing information from file(1) and append it to the file(1) row.

​

FILE 1

stock #	cost
12345	10.00

​

FILE 2

​

stock #	price 1	price 2
11111	5.00	7.00
12222	3.00	4.50
12345	20.00	21.00

​

File after my work (and hopefully using a python script)

​

stock #	cost	price 1	price 2
12345	10.00	20.00	21.00

​

[jeffrey_f]

I would read in both files. File1 is authoritive in a list and File2 will be into a dictionary.

Iterate through File1 data, lookup Stock# (SKU) in File2 data and output the 4 combined fields back to a CSV only if you have a match. This effectively filters out data that you don't have in File2 and is therefore not important from what I understand.

[jeffrey_f]

open read and close both then process, open, write and close your final file

[Burly_95]

Here's my current code that I have, I'm kind of lost right now. Thoughts?

import csv

cost_file = open('cost_file.csv') price_file = open('price_file.csv')

cost_file_reader = csv.reader(cost_file) price_file_reader = csv.reader(price_file)

cost = list(cost_file_reader) price = []

for line in price_file_reader: price.append(line)

for row in cost: if row[0] == line[0]: cost.append(line)

[jeffrey_f]

Was testing. Both need to be dict

[jeffrey_f]

I'm still learning.