Himalaya Bir ShresthainTowards Data ScienceManaging Pivot Table and Excel Charts with VBASave precious hours by automating working with pivot tables and charts using VBA9 min read·5 days ago----
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.6 min read·May 4, 2024----
Himalaya Bir ShresthainTowards Data ScienceArrays in Python and Excel VBALearning about arrays through simple examples8 min read·Jan 23, 2024--1--1
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…7 min read·Dec 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 them7 min read·Sep 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.10 min read·Jun 5, 2023----
Himalaya Bir ShresthainTowards Data ScienceHandling Time Zones with PythonThis post demonstrates the functionalities to deal with time zones in Python10 min read·Apr 21, 2023--1--1
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 VBA11 min read·Apr 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 format10 min read·Jan 25, 2023--2--2
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 anomaly12 min read·Oct 11, 2022--3--3