Download pdf from a site, scrape data and save on google sheet -- 3
₹1500-12500 INR
Betales ved levering
The project entails this:
A) download the three attached pdf files from the website daily. The exact time varies within a window of 1 hr. Store these pdfs on a google drive folder.
B) Extract table data from the pdf's and store as an excel sheet on google drive DAILY. One excel file for each pdf. Separate tab for the tables. Alternatively find data from other parts of the website and store them in excel files.
C) Following tables to be extracted:
a) From file ***[login to view URL]
1) Regional Prices, pg1
2) Daily Canadian supply demand, pg1
3) Demand, pg 3
4) Storage Inventory, pg4
5) All three tables, pg 5
6) All three tables, pg 6
7) Production, pg 7
b) from file ***[login to view URL]
1) Modeled Regional power burn, pg1
2) Forward week forecast, pg2
3) Weekly Sum, pg2
4) Nuclear plant summary, pg3
5) two tables on wind generation, pg 5
6) Northeast power burn, pg 6
7) Southeast power burn, pg7
8) Texas power Burn, pg8
9) Rockies PB, pg8
10) Midwest PB, pg 9
11) Midcon PB, pg 9
12) South west PB, pg10
13) Pacific NW PB, pg 10
c) from file ***[login to view URL]
1) US Supply demand, pg1
2) Gas Market Fundamentals, pg2
3) Avg population weighted HDD/CDD, pg 6
4) Avg population weighted Temperatures, pg6
5) 2 tables on pg7
6) 3 tables on pg8.
D) A smaller set of the extracted data to be put on a google sheet. Format to be provided by me.
F) IMPORTANT: The coding has to be done using google scripts only. The data has to be stored on google drive and google sheets ONLY. No Exceptions.
G) The format of the pdf might change in its embedding, internal structure, so the program has to be smart enough to bypass these hurdles.
This project requires a code that can do this:
1) Download the files daily
2) Convert the pdf data to a excel table
This all has to be automated and not a manual conversion of tables.
Prosjekt-ID: #10459412
Om prosjektet
21 frilansere byr i gjennomsnitt ₹8104 for denne jobben
Hello sir, Consider it as done. PDF TO word/excel/google sheet expert here . But i guess you forgot to attach the pdf :D Give me the pdf in pm so i can have a look and confirm you. Waiting for your reply. Thank Mer
I can do this task because I have worked on such kind of tasks earlier. I have worked almost 6 years in eCommerce department.
Hi, thanks for sharing your requirements, I can do this project as already delivered many projects of data scraping, excel works, data mining and data analysis. Looking forward to your reply. Regards Ravi K.
Time is money. I will definitely complete your task in given time. No room for an error. I will do my best.