We'd like to have a small python script that extracts some data from a JSON and adds it to a CSV. Really simple job. Less than one hour of work.
Looking forward to you!
The logic is like this:
Input 1: A JSON that, among others, contains the following fields:
Input 2: A CSV that has the following fields:
The CSV - with the data from the json added to it (input dates should be converted to "weeks of the year" ([login to view URL]))
So the flow is like this:
1) Read input from a json
2) convert the dates into a "week of the year" ([login to view URL])
3) append the records from the json to the csv with the following mapping:
-> JSON: ListedSince -> CSV: ListedSince; week of the year -> WeekOfYearOfListedSince
-> JSON: ParsedDate -> CSV: CrawledAt; week of the year -> WeekOfYearOfCrawledAt
4) check the csv for duplicate product IDs and remove the duplicates