I have use https://openweathermap.org/ for getting the weather Information I have use Pandas for Excel Operations and requests for Open Weather API Handling in Python
There 2 Excel Files
- Containing Supported Cities Names
- Containing the Actual Application - Live-Weather.xlsx
The reason for making the cities file separated is due to file reading and writing operations
To add new city
-
Open Live-Weather.xlsx
-
Add City name, Add Unit Value(K/C/F), and Add Update value (0 for no updation, 1 for updating values). Note: All of the values mentioned are required. Rest all values will be updated when Program will run and will see the Update parameter.
-
Run the main.py
There is main.py file while loads the Live-Weather.xlsx and checks for all Rows and then updates all necessary rows