Sedang Disiapkan

Python Script to modify csv files

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.

[url removed, login to view] processes the main data file named [url removed, login to view]

[url removed, login to view] processes the inventory data file called inventory [url removed, login to view]

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 ([url removed, login to view]) 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 ([url removed, login to view]) 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 ([url removed, login to view]) 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 ([url removed, login to view]) I need the map_price routines made in ([url removed, login to view]) 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 [url removed, login to view] written to work with the data file [url removed, login to view] 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 [url removed, login to view] but like this.

outrow['Available']="Y"

outrow['Supplier']="New Jersey"

Kemahiran: Python

Lihat lebih lanjut: python modify csv file, modify csv python, modify file python, modify csv file python, python modify file, python csv modify, changing data csv file python, modify csv files python, python modify data file, python script csv, python modify csv, python csv script, python csv file, python process_data, csv python, modifying csv file using python, python csv scripts, python script data extraction csv, csv python script, python csv tab delimited, perl modify csv, script modify text file, python parse csv, script modify csv file, python csv files

Tentang Majikan:
( 17 ulasan ) Port Richey, United States

ID Projek: #337369

Dianugerahkan kepada:

glyph

Hello, I just had finished a similar project. I've got some considerations. Read PM, please.

$50 USD dalam 5 hari
(6 Ulasan)
3.3

13 freelancers are bidding on average $102 for this job

hameedkhan

Ready to do it, have a look at PM. Thanks.

$100 USD dalam 0 hari
(18 Ulasan)
4.6
zeke

Dear Sir! I am an expert. Ready to start and finish within 2 days. My bid is for fast professional service exciting my customers. Please contact in PM if you have any questions. Best Regards, Zeke

$150 USD dalam 2 hari
(10 Ulasan)
4.4
Arenabpo

Hello, I am expert, let me do it for you. Thank you!

$250 USD dalam 3 hari
(2 Ulasan)
4.3
sentromed

Hello, 2-3 days work for good python dev (and for me). maybe 5 for beginner. You know perl and have sources, isn't difficult to do it yourself? Valery.

$240 USD dalam 3 hari
(2 Ulasan)
3.9
marchent

check your pmb for details.

$125 USD dalam 5 hari
(8 Ulasan)
3.4
terry001

can do . experienced data extraction csv .

$30 USD dalam 4 hari
(1 Ulasan)
0.0
Fynda

I already wrote similar scripts before, so I think I can modify yours one correctly.

$40 USD dalam 2 hari
(0 Ulasan)
0.0
lunsford2000

Professional C, Java, Python, mySql developer ready to implement your project quickly and completely.

$75 USD dalam 2 hari
(0 Ulasan)
0.0
vfigueiro

I'm very experienced in this kind of scripting. I'll deliver and document it with good quality and on time.

$70 USD dalam 2 hari
(0 Ulasan)
0.0
Oriens

Could be done in 1-2 days.

$60 USD dalam 2 hari
(0 Ulasan)
0.0
watcom

Very well defined project, it should be pretty straightforward. I'll do it for the rating. Thank you!

$40 USD dalam 2 hari
(0 Ulasan)
0.0
nicolasp

Full time researcher in IA domain. I develop principally in Python. Please contact me for more details.

$100 USD dalam sehari
(0 Ulasan)
0.0