Receiving several price / info feeds from PDF (by e-mail) / WhatsApp
Wish to use Python to parse the text, extract relevant information and insert rows into a cloud SQL database. The end goal is to visualize the data using a BI application i.e. Power BI / Tableau.
Have tried out GCP, Azure and AWS.
Planning to use Google Cloud SQL, but welcome other suggested solutions with lower cost.
There will be several templates / formats of info received - not interested in a static code solution.
The successful bidder needs to be able to explain how the data is being extracted and inserted into the defined schema so that I am able to write my own code to handle future changes in data formatting.
Example of data:
8 SOYOIL EU degummed euro tonne fob exmill --> Commodity
10 Feb19 --> Delivery_Start 695.00 --> Price +10.00 --> Price_Change
11 Mar19 685.00 +10.00
12 Apr19 670.00 +15.00
13 May19 650.00 +25.00
14 Jun19 645.00 +20.00
15 Jul19/Aug19 640.00 +15.00
16 Sep19/Oct19 650.00 +25.00