Himalaya Bir ShresthainTowards Data ScienceManaging Pivot Table and Excel Charts with VBASave precious hours by automating working with pivot tables and charts using VBAJun 18Jun 18
Himalaya Bir ShresthainTowards Data ScienceDissolving map boundaries in QGIS and PythonThis post describes some interesting processes for transforming the map boundaries in vector datasets using QGIS and geopandas in Python.May 41May 41
Himalaya Bir ShresthainTowards Data ScienceArrays in Python and Excel VBALearning about arrays through simple examplesJan 231Jan 231
Himalaya Bir ShresthainTowards Data ScienceVisualizing trade flow in Python maps — Part I: Bi-directional trade flow mapsThe exchange of goods and services in exchange for their corresponding values is an intricate part of our daily life. Similarly, countries…Dec 16, 2023Dec 16, 2023
Himalaya Bir ShresthainTowards Data ScienceCreating a Project Updates Tracker in Excel Using VBAThree simple steps to track project updates in Excel and log themSep 2, 2023Sep 2, 2023
Himalaya Bir ShresthainTowards Data ScienceAssessing global temperature anomaly using NASA’s space studies - Part IIPlotting global surface temperature anomaly data obtained from NASA’s GISSTEMP using cartopy, matplotlib and netCDF data in Python.Jun 5, 2023Jun 5, 2023
Himalaya Bir ShresthainTowards Data ScienceHandling Time Zones with PythonThis post demonstrates the functionalities to deal with time zones in PythonApr 21, 20231Apr 21, 20231
Himalaya Bir ShresthainTowards Data ScienceRunning Python via Excel VBA —a Case of Time Series ResamplingA comprehensive assessment of time series resampling of solar irradiance using VBA, using Python, and using Python via Excel VBAApr 17, 2023Apr 17, 2023
Himalaya Bir ShresthainTowards Data ScienceA complete word processing with PythonReading pdf file, utilizing regular expressions, exporting to Excel and Word document, and converting it back to pdf formatJan 25, 20232Jan 25, 20232
Himalaya Bir ShresthainTowards Data ScienceAssessing global temperature anomaly using NASA’s space studies — Part IExploring the underlying data, uncertainties, and science behind the historical global temperature anomalyOct 11, 20223Oct 11, 20223