dataforgoodfr / CarbonBombs

17 stars 0 forks source link

Add address for companies added during commit d09524679c06af9bb7623ee82f8a0ae733117b11 #122

Closed mnicolleUTC closed 1 year ago

mnicolleUTC commented 1 year ago

Many companies have been added during the mapping of extraction sites in a shale. Therefore, it is important to regenerate the addresses of the headquarters for these new companies in the data_sources/Data_chatGPT_company_hq_adress.csv file, so that the data_cleaned/company_data.csv file can be completed with the addresses, latitude, and longitude

mnicolleUTC commented 1 year ago

The prompt used to generate the addresses is the following : Please provide the headquarters address (in the limit of you knowledge) of the following fossil fuel companies. When the address is unknown, provide the country and its capital instead. Format the output with each company’s information on a new line so I can copy-paste directly into Excel rows. Use a semicolon to separate the company name and address and ensure there are no semicolons in the address itself. Format the output this way : line number. address, city, country, when you know just the country just give me the country, When you just don’t know please just indicate Unknown Here is the list of companies : XXX XXX XXX ...

The model used to generate the address is : ChatGPT September 25 Version

mnicolleUTC commented 1 year ago

Encana Oil & Gas is now named Ovintiv : Must add a manual match to linked those companies

mnicolleUTC commented 1 year ago

Here is the file of data generated with ChatGPT temp.csv

mnicolleUTC commented 1 year ago

Here is the file with data scrape manually Missing Address Fossil Fuel companies - Feuille 1.csv