0 views collected around this technical thread.
This article demonstrates how to replace common Excel operations such as VLOOKUP, data pivot tables, and charting with Python's pandas and plotly libraries, providing code examples, explanations of data import/export settings, and performance considerations for large‑scale data analysis.
This article explains how to use Shell scripts together with Excel VLOOKUP to extract OceanBase cluster Parameters, Variables, and ProxyConfig values, compare them against default or DBA‑tuned settings, and generate a report that highlights unexpected configurations for manual verification.
This article demonstrates how to replace typical Excel operations such as data import, VLOOKUP, pivot tables, and charting with Python's pandas and Plotly libraries, providing code examples and step‑by‑step explanations for each task.
This article demonstrates how to replace typical Excel operations such as VLOOKUP, pivot tables, duplicate removal, missing‑value handling, multi‑condition filtering, fuzzy matching, column splitting, outlier replacement, grouping and labeling with concise Python pandas code to streamline data analysis workflows.
This article demonstrates how to replace Excel's common data‑analysis tasks—such as VLOOKUP, data import/export, pivot tables, and charting—by using Python's pandas library together with Plotly for visualization, providing code examples and performance tips for each scenario.
This article demonstrates how to replace common Excel operations such as data import, VLOOKUP, pivot tables, and charting with Python libraries like pandas and plotly, providing step‑by‑step code examples, performance tips, and comparisons that help analysts transition from spreadsheet‑based workflows to programmatic data analysis.
This article demonstrates how to replace typical Excel tasks such as VLOOKUP, pivot tables, duplicate removal, missing‑value handling, multi‑condition filtering, and grouping with concise Python pandas code, providing step‑by‑step examples and practical tips for efficient data analysis.
This article demonstrates how to replace typical Excel operations such as data import/export, VLOOKUP, pivot tables, and chart creation with Python libraries pandas and plotly, providing code examples and explanations for each task.
This tutorial demonstrates how to import Excel data into Pandas, reproduce IF and VLOOKUP functionality, and generate pivot tables with Python, highlighting the differences between Excel and Pandas and showing why Python can be a more reusable and scalable solution for data analysis.
This guide shows data product managers how to master essential Excel features—including pivot tables, VLOOKUP, and the Text‑to‑Columns tool—so they can turn raw data into actionable insights and implement data‑driven product strategies efficiently.