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 a real‑world question about grouping 5,000 nationwide records by province to compute counts, totals, averages and ratios, compares using Excel pivot tables, SQL, and demonstrates a concise Python pandas pivot_table solution.
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 walks through a real‑world pandas question on reshaping Excel data using pd.pivot_table, presenting the problem, showing the original and target layouts, and providing concrete code snippets that successfully solve the issue.
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 use AntV S2 in a React project to create a multi‑dimensional table for quickly filtering, sorting, paginating, and highlighting ideal housing units during a fast‑paced on‑site selection process, complete with code snippets and visual examples.
This tutorial shows how to group pandas data by two columns, count occurrences, and reshape the result so that the secondary condition becomes column headers, presenting three practical methods with code examples and visual explanations.
This tutorial demonstrates how to reshape a one‑dimensional pandas DataFrame into a two‑dimensional format using both pivot_table with a custom aggregation function and the unstack method, providing step‑by‑step code, visual results, and practical tips for handling larger datasets.
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 reshape a one‑dimensional dataset into a two‑dimensional table using pandas, covering the data requirements, import steps, and two practical methods—pivot_table with a custom aggregation function and the unstack technique—complete with code snippets and visual results.
This article walks you through automating daily loan reporting for a bank using Python and pandas, covering data loading, date filtering, table splitting, column renaming, concatenation, missing‑value handling, calculated fields, and pivot‑table generation to replace repetitive Excel tasks.
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 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.
