InAI AdvancesbyWei-Meng LeeGeospatial Data Analysis using DuckDBSimplifying Spatial Data Analysis with DuckDB’s Spatial ExtensionsJan 12Jan 12
InAI AdvancesbyWei-Meng LeePerforming Analytical Queries with LLMsA Practical Approach to Using LLMs for Data Exploration and AnalysisJan 10Jan 10
InLevel Up CodingbyWei-Meng LeeIntegrating ChatGPT into Jupyter NotebookYou can now directly access ChatGPT from your Jupyter NotebookMay 26, 20231May 26, 20231
InLevel Up CodingbyWei-Meng LeePandasAI — Leveraging on the Power of LLMs to work with Pandas DataFramesYou can now use artificial intelligence to make working with dataframes a less painful taskMay 21, 20232May 21, 20232
InLevel Up CodingbyWei-Meng LeeUnderstanding Groupby() Function in Pandas Dataframe — Part 1The groupby() function is one of the most useful functions when dealing with large dataframes in Pandas. A groupby operation typically…Jul 17, 2020Jul 17, 2020
InTDS ArchivebyWei-Meng LeeJoining Pandas DataFramesLearn how to merge Pandas Dataframes easilyAug 27, 20212Aug 27, 20212
InTDS ArchivebyWei-Meng LeeManipulating Values in Pandas DataFramesKnow when to use map(), apply(), and applymap()Aug 28, 2021Aug 28, 2021
InTDS ArchivebyWei-Meng LeeWorking with Multi-Index Pandas DataFramesLearn how to work with multi-index dataframes with easeAug 30, 20214Aug 30, 20214
InTDS ArchivebyWei-Meng LeePerforming Groupings on Multi-Index Pandas DataFramesExploring the set_index() and groupby() functionsSep 4, 20211Sep 4, 20211
InTDS ArchivebyWei-Meng LeeStill Saving Your Data in CSV? Try these other optionsLearn how to save your data in different formats (CSV, compressions, Pickle, and Parquet) to save storage and reduce read/write time, and…Nov 22, 20211Nov 22, 20211
InTDS ArchivebyWei-Meng LeeDeveloping the Go Game (围棋) using matplotlib and NumPy — Part 1Drawing the Go Board using matplotlibNov 29, 2021Nov 29, 2021
InTDS ArchivebyWei-Meng LeeDeveloping the Go Game (围棋) using matplotlib and NumPy — Part 2Implementing the rules of GoDec 14, 20211Dec 14, 20211
InTDS ArchivebyWei-Meng LeeQuerying Pandas DataFrames using the query() MethodLearn how to query your Pandas DataFrames using SQL-like syntaxJul 22, 20221Jul 22, 20221
InLevel Up CodingbyWei-Meng LeePerforming Exploratory Data Analysis (EDA) using Pivot Tables in PandasLearn how to use the pivot_table() function in Pandas to aggregate your dataJul 27, 2022Jul 27, 2022
InLevel Up CodingbyWei-Meng LeeUsing DuckDB for Data AnalyticsLearn how to use SQL to perform data analyticsFeb 12, 20231Feb 12, 20231
InTDS ArchivebyWei-Meng LeePlotting Chord Diagrams in PythonHow to use Holoviews to plot chord diagrams to show relationships between various data attributesFeb 15, 20232Feb 15, 20232
Wei-Meng LeePandas Display Options CheatsheetHere is a cheatsheet for Pandas developers to customize their display options.Feb 16, 2023Feb 16, 2023
InTDS ArchivebyWei-Meng LeeMaking Your Data Analytics Come to Life using ipywidgetsLearn how to use widgets to dynamically update your data analyticsFeb 21, 2023Feb 21, 2023
InLevel Up CodingbyWei-Meng LeeLoading JSON Files using DuckDBLearn the tips and tricks to load JSON files directly into DuckDBFeb 21, 20232Feb 21, 20232
InTDS ArchivebyWei-Meng LeeRunning SQL Queries in Jupyter Notebook using JupySQL, DuckDB, and MySQLLearn how to run SQL in your Jupyter NotebooksFeb 24, 20232Feb 24, 20232