1 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 the fundamentals of multi‑dimensional (pivot) tables, describes core BI concepts such as dimensions, hierarchies, members and indicators, and shows how VTable maps these concepts to configuration options, data analysis features, custom dimension trees, and real‑world use cases.
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 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 tutorial demonstrates how to use Python's requests and BeautifulSoup libraries to scrape the titles and release years of the 250 movies listed on Douban, clean the extracted data, output it for Excel, and then create a pivot table and chart to visualize the yearly distribution of top films.
This article presents eight practical Python data‑analysis techniques—including one‑line list definitions, lambda expressions, map and filter functions, NumPy arange/linspace, Pandas axis handling, DataFrame concatenation/merging/joining, the apply method, and pivot tables—each illustrated with clear code examples and explanations.
This article demonstrates how to automate the creation of Excel pivot tables using Python's pandas library, build a Tkinter GUI for user interaction, and package the solution into a standalone executable with PyInstaller, including steps for managing dependencies and reducing file size.
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.