This is an old revision of the document!
SDG Africa Partnership
Workshop with Ellen and Charles, two scientists from Makerere University Kampala, Uganda, together with Clein and Rolf from HSRW
2023-11-07
- Download and install of QGIS
- Download and install anaconda
- conda environment creation
- installation of libraries according to
https://github.com/rolfbecker/EE_3.07_Geodata_WS2022/tree/main/gdms0020_Course_Preparation - Correction of packages: jupyterlab pandas geopandas shapely fiona pyproj rasterio sqlalchemy psycopg2 ipython-sql bs4
- https://cs231n.github.io/python-numpy-tutorial/ up to numpy
Extra material:
- pandas tutorial (comprehensive):
https://github.com/ageron/handson-ml3/blob/main/tools_pandas.ipynb
2023-11-08
* Finished the numpy tutorial from cs231. Skipped the image processing for now * Followed partially the hands-on-ml3 tutorial (tools_pandas.ipynb). Material covered: - import pandas and alias - Series: create from list, give index, give name, create from dictionary. slicing, alignment, plotting - Handle time with pd.date_range() - Creating a Dataframe: by dictionary. - selecting columns, accesing values, filtering, transposing. skipped multi-indexing, stacking and unstacking, - datafream read: read_csv and read_excel. And dat frame write
Homework: explore the real data: https://firebasestorage.googleapis.com/v0/b/fao-aquastat.appspot.com/o/Excel%2FAfrica-dams_eng.xlsx?alt=media&token=b621f090-60cf-46f1-8472-9003ce314066