A step-by-step workflow for analysing Excel workbooks with multiple sheets. It covers reading data, cleaning it, filtering and combining results, and exporting reports, with a separate strategy for large files.
A workflow for processing large Excel workbooks by counting their rows, converting them to Parquet when needed, and finding maximum values. Parquet is a data-file format designed for efficient reading.
An Excel workflow for finding values that exceed stated limits and identifying cells containing errors, then highlighting them. The example focuses on comparing calculated heat-transfer values with limits described in the sheet.
An Excel analysis step that counts rows, calculates average values for a selected entity over time, and creates a styled report with color-based formatting. It can switch to Parquet, a column-based data format, for larger files.
A workflow for combining data from multiple Excel sheets, finding the top results, and highlighting important values in a formatted workbook. It uses Python tools for reading, cleaning, analysing, and styling spreadsheet data.
A spreadsheet analysis for comparing two sets of categories. It cleans data from Excel sheets, counts each category, calculates differences and proportions, and creates comparison charts.
A workflow for cleaning spreadsheet data, preparing large Parquet files, grouping rows into categories, and producing summary tables and charts. Parquet is a column-based file format often used for large datasets.
A data-analysis workflow for large spreadsheets or datasets. It can choose a more suitable reading format, check whether measurements use consistent units, and rank key indicators.
A data-analysis method that groups records into a cross-tabulation, also called a pivot table, and shows category totals and percentages. A heatmap can then make differences between categories easier to see.
A data-analysis process for finding trends in values recorded over time or grouped into categories. It also covers percentage cleaning, performance levels, forecasts, and high-resolution charts.
A data-cleaning workflow for large Excel files. It can combine sheets, use the Parquet file format for larger datasets, and remove unwanted characters from a selected text column while keeping Chinese characters.
An Excel data-cleaning workflow for converting selected columns to numbers, calculating totals, checking them against a summary sheet, and exporting results. Excel is a spreadsheet program, and Parquet is a compact file format for tabular data.
A data-quality workflow that finds unusually high or low values and examines how numerical data is distributed. The interquartile range, or IQR, is a spread measure used here to flag possible outliers.
Instructions for cleaning spreadsheet text and number columns, including removing stray prefixes from numbers and keeping only Chinese characters in selected text.
A workflow for filtering Excel spreadsheet rows using several numeric conditions and exporting the matching results. Excel is a spreadsheet format that can contain multiple worksheets and large tables.
A workflow step for analyzing Excel file size, cleaning numeric columns, filtering rows by a threshold, and marking matching cells with openpyxl. It is part of a larger Excel processing workflow.