Python data formatting
Budget: £10 – £20 GBP
I am looking for a Python developer who can help me with data formatting.
I have two JSON files that require the need to be formatted in a very particular way
In essence within the json files I need elements to be picked out and placed within rows in an excel file basically looping through each elements and printing them onto a new_format csv file.
After that’s done I require a scan of the csv file checking for rows with the the words INGRED in it, if it exists to grab the product description string next to it to product Id and check to see if there is a similar string within a new_products.csv file the closest match string to grab the product Id of it and place it in new_format.csv file and loop through all.
There is about 1578 rows in the new_products csv there’s also in the json file about 1267 different groups of rows that needs to be made so the script needs to be performance effiecent
I attempted to do this myself by came up short as it was taking too long at the fuzzywuzzy rapidfuzz part trying to match and assign the new ids
If you can also explain your code and how you efficiently achieved this would be great. I’ll attach my work and requires files
Data Type: JSON
- The data that needs to be formatted is in JSON format.
Schema: Yes
- I have a specific schema in mind for the formatting.
Number of Files: 1-5
- I have 1-5 files that need to be formatted.
Skills and Experience:
- Proficient in Python programming language
- Experience with JSON data formatting
-Experience with Excel csv
- Knowledge of schema design
- Attention to detail and ability to follow specific formatting requirements
I have two JSON files that require the need to be formatted in a very particular way
In essence within the json files I need elements to be picked out and placed within rows in an excel file basically looping through each elements and printing them onto a new_format csv file.
After that’s done I require a scan of the csv file checking for rows with the the words INGRED in it, if it exists to grab the product description string next to it to product Id and check to see if there is a similar string within a new_products.csv file the closest match string to grab the product Id of it and place it in new_format.csv file and loop through all.
There is about 1578 rows in the new_products csv there’s also in the json file about 1267 different groups of rows that needs to be made so the script needs to be performance effiecent
I attempted to do this myself by came up short as it was taking too long at the fuzzywuzzy rapidfuzz part trying to match and assign the new ids
If you can also explain your code and how you efficiently achieved this would be great. I’ll attach my work and requires files
Data Type: JSON
- The data that needs to be formatted is in JSON format.
Schema: Yes
- I have a specific schema in mind for the formatting.
Number of Files: 1-5
- I have 1-5 files that need to be formatted.
Skills and Experience:
- Proficient in Python programming language
- Experience with JSON data formatting
-Experience with Excel csv
- Knowledge of schema design
- Attention to detail and ability to follow specific formatting requirements