Project Detail

Description

I currently have a couple of Python scripts that takes a csv file and modifies the data and writes it to a new csv file in a TAB delimited format that I need some changes to be made to. Please read this file carefully. I tried to include everything I needed done in this project description but some small changes/tweaks may need to be made during the process.

The scripts are attached to this project for reference.

Process_data.py processes the main data file named data-sample1.csv

Process_inventory.py processes the inventory data file called inventory data2.txt

The new features I need added are.

Both scripts need to be able to read a txt file that contains a list of the item_no/Product_code’s that will be written to the output file. All other records will be ignored.

In (process_data.py) I need to be able to override certain product categories that are written to the output file using another txt file that would contain two fields per line (source Category, output category)

In (process_data.py) if the input record has a map_price set the in the output file the record map_price should be set to “Y” and the output list_price field should be set to the input value of map_price.

If no map_price is set in the input file then may_price in the output file should be set to “N” and list_price in the output file should be set to the input file value MSRP.

In (process_inventory.py) Right now it calculates the output file price value using this formula.
outrow['Price']=str(float(inrow['price'] or 0 )*1.10)

I need it to read a text file that would contain the product_code/item_no with the price override that should be written to the output file. If it’s not found in the text file it should just default to the formula above.

In (process_inventory.py) I need the map_price routines made in (process_data.py) duplicated the same way.
I need a second set of the above scripts to work a little differently.

Instead of only writing records based on the list of product codes, I need the opposite where it ignores records in the list. I also need a way to ignore records written to the output file based on the input file value ‘brand’ so certain brand products are not written.
I have a second input data file that I also need to process the same as the above methods.

I need a third version of process_data.py written to work with the data file data-sample2.csv this file does not have a header that contains the record names though. Right now they are like this.
'Product code','Detailed image','Product name','Description','Price','map_price','Weight','Quantity','Manufacturer','Category'
The output file needs to be I the same format as the other data file and needs to have new static fileds added just like the process_data.py but like this.
outrow['Available']="Y"
outrow['Supplier']="New Jersey"









Additional files submitted:
process_data.py
process_inventory.py
inventory data2.txt
data-sample2.csv
data-sample1.csv