Skip to content

RoseLV/GU-data-analytics

Repository files navigation

Requirement:
# Run python3 (按顺序依次运行:db_create.py, sql_temp.py, excel_temp.py, numpy_temp.py) in terminal(终端).
1.Run 'db_create.py' to
    - Open the excel files,
    - Create a SQLite database with three tables,
    - Import data from the excel files to the corresponding tables in the database.

2. Run 'sql_temp.py' to query the database
    - Print distinctive major cities located in southern hemisphere ordered by country,
    - Write their name, country, and geo-location into a new table called “Southern cities”,
    - Print maximum, minimum and average temperature of Queensland for year 2000 and print this information to the CONSOLE.

3. Run 'excel_temp.py' to
    - Create a new workbook named “World Temperature.xlsx”.
    - Create a sheet named “Temperature by city”.
    - Calculate the yearly mean temperature of each city in China (Contain some missing data).
    - Write the relevant data into the worksheet you created.
    - Generate a line chart for the above data.

4. Run 'numpy_temp.py' to
    - Open the World Temperature workbook,
    - Create another sheet called “Comparison”,
    - Calculate mean yearly temperature of Australian states,
    - Calculate mean yearly temperature of Australia,
    - Calculate yearly differences between each state and the national data,
    - Use MatPlotLib to plot the difference across years,
    - Write the data into the sheet.

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages