Python Developer for Excel File Data Extraction
Budget: $8 – $15 USD
I'm in need of a proficient Python developer who can design functions enabling automation of data entry tasks. The job involves extracting rules and descriptions from Excel files, with varying types of data including both numerical and textual.
Ideal skills and experience:
- Expertise in Python
- Experience with Excel and automating data entry
- Understanding of diverse types of data, both numerical and textual
This is the type of services I am looking for:
You must use the Excel file "Vollversion_FTA_List_Rules.xlsx", available on the following website : https://www.bazg.admin.ch/bazg/fr/home/services/services-firmen/services-firmen_einfuhr-ausfuhr-durchfuhr/zolltarif-tares/datenlieferungen.html
The "Bilateral agreements_List_Rules.xlsx" which uses the same format, should also be supported by your solution :
image.png
With these files, you must provide a way (the best would be a python function), from a heading number and an origin country, to get :
- a description (for example with a getDescription(heading_number,origin_country) function)
- a list of rules (there can be more than one rule per description), which give the preferential origin status (for example a getRules(heading_number,origin_country) function )
Consider the following example :
image.png
A call to getDescription(2007,Georgia) should return "Jams, fruit jellies, marmalades, fruit or nut purée and fruit or nut pastes, obtained by cooking, whether or not containing added sugar or other sweetening matter"
A call to getRules(2007,Georgia) should return "Manufacture from materials of any heading, except that of the product, and in which the value of all the materials of Chapter 17 used does not exceed 30 % of the ex-works price of the product"
However, the biggest challenge is the irregularity of the input files
Consider another example :
image.png
A call to getDescription(2008,Ecuador) should not directly return the description, but ask for a choice between the 3 possibles descriptions, that is :
- "Fruit, nuts and other edible parts of plants, otherwise prepared or preserved, whether or not containing added sugar or other sweetening matter or spirit, not elsewhere specified or included: Prepared or conserved palm hearts"
- "Fruit, nuts and other edible parts of plants, otherwise prepared or preserved, whether or not containing added sugar or other sweetening matter or spirit, not elsewhere specified or included: Prepared or conserved palm hearts : Mixtures"
- "Fruit, nuts and other edible parts of plants, otherwise prepared or preserved, whether or not containing added sugar or other sweetening matter or spirit, not elsewhere specified or included: Prepared or conserved palm hearts : Other"
The way to do this is left to be specified, but should be as simple an effort free as possible for the end user of getDescription.
In a similar way, a call to getRules(2008,Ecuador) shoud ask for a choice between the 3 possibles rules, which are directly related to the chosen description, that is :
- "Manufacture in which all materials used are classified within a chapter other than that of the product, except for those of Chapter 12"
- "Manufacture in which all materials used are classified within a chapter other than that of the product, except for those of Chapters 7"
- "Manufacture in which all materials used are classified within a chapter other than that of the product provided that the value of all materials used does not exceed 50% of the ex–works price of the product"
In these files, there are a lot of irregularities of this kind. We are also asking for an exhaustive list of theses irregularities. For each of them, a solution should be proposed in a way that the end user of getDescription and getRule should have to make as little effort as possible, while getting the informations in the file in a reliable way.
Ideal skills and experience:
- Expertise in Python
- Experience with Excel and automating data entry
- Understanding of diverse types of data, both numerical and textual
This is the type of services I am looking for:
You must use the Excel file "Vollversion_FTA_List_Rules.xlsx", available on the following website : https://www.bazg.admin.ch/bazg/fr/home/services/services-firmen/services-firmen_einfuhr-ausfuhr-durchfuhr/zolltarif-tares/datenlieferungen.html
The "Bilateral agreements_List_Rules.xlsx" which uses the same format, should also be supported by your solution :
image.png
With these files, you must provide a way (the best would be a python function), from a heading number and an origin country, to get :
- a description (for example with a getDescription(heading_number,origin_country) function)
- a list of rules (there can be more than one rule per description), which give the preferential origin status (for example a getRules(heading_number,origin_country) function )
Consider the following example :
image.png
A call to getDescription(2007,Georgia) should return "Jams, fruit jellies, marmalades, fruit or nut purée and fruit or nut pastes, obtained by cooking, whether or not containing added sugar or other sweetening matter"
A call to getRules(2007,Georgia) should return "Manufacture from materials of any heading, except that of the product, and in which the value of all the materials of Chapter 17 used does not exceed 30 % of the ex-works price of the product"
However, the biggest challenge is the irregularity of the input files
Consider another example :
image.png
A call to getDescription(2008,Ecuador) should not directly return the description, but ask for a choice between the 3 possibles descriptions, that is :
- "Fruit, nuts and other edible parts of plants, otherwise prepared or preserved, whether or not containing added sugar or other sweetening matter or spirit, not elsewhere specified or included: Prepared or conserved palm hearts"
- "Fruit, nuts and other edible parts of plants, otherwise prepared or preserved, whether or not containing added sugar or other sweetening matter or spirit, not elsewhere specified or included: Prepared or conserved palm hearts : Mixtures"
- "Fruit, nuts and other edible parts of plants, otherwise prepared or preserved, whether or not containing added sugar or other sweetening matter or spirit, not elsewhere specified or included: Prepared or conserved palm hearts : Other"
The way to do this is left to be specified, but should be as simple an effort free as possible for the end user of getDescription.
In a similar way, a call to getRules(2008,Ecuador) shoud ask for a choice between the 3 possibles rules, which are directly related to the chosen description, that is :
- "Manufacture in which all materials used are classified within a chapter other than that of the product, except for those of Chapter 12"
- "Manufacture in which all materials used are classified within a chapter other than that of the product, except for those of Chapters 7"
- "Manufacture in which all materials used are classified within a chapter other than that of the product provided that the value of all materials used does not exceed 50% of the ex–works price of the product"
In these files, there are a lot of irregularities of this kind. We are also asking for an exhaustive list of theses irregularities. For each of them, a solution should be proposed in a way that the end user of getDescription and getRule should have to make as little effort as possible, while getting the informations in the file in a reliable way.