Clean Excel columns by removing unwanted prefixes from numeric values and extracting Chinese characters from text. Add the cleaned results as new columns, then save an Excel file and provide a download link.
Turn percentage strings into numeric data, calculate the remaining share needed to reach 100%, and create stacked bar charts. Compare category composition across periods or groups and save the chart as a high-resolution image.
Process multi-sheet Excel data by finding columns through keywords and counting specified values. Clean text fields to retain Chinese characters, then export the processed data as an Excel file with its size and download link.
Count rows across Excel sheets to assess data size, then analyze an existing Parquet file, a format for storing tabular data. Calculate category counts and percentages, and save the results as an Excel summary and a pie chart.
Combine data from multiple Excel sheets, clean inconsistent labels and merged cells, and summarize counts by category. Create Excel summary tables with percentages and totals, plus labeled bar charts for comparing categories.
Clean a target Excel column, convert its values to numbers, and compare the calculated total with a summary sheet. Export the totals, match status, and difference in Excel and CSV files.
Scan multiple Excel sheets for rows with missing or invalid entries in a target column. Combine matching records with their source sheet names, then export an Excel file with every extracted data row filled red for review.
Analyze one Excel worksheet by cleaning column names, extracting numbers, and handling gaps from merged cells. Create category counts, percentages, cross-tabulations comparing groups, high-resolution charts, and CSV exports, with Parquet storage for the data.
Clean Excel data and group records with similar numerical features. Produce a combined view of indicator trends, value distributions, category shares, and grouped data, then export the charts as an image and cleaned records as Excel.
Filter rows from Excel or previously converted Parquet files, a format designed for efficient data storage. Summarize matching records by group with counts, percentages, and totals, then export the summary to Excel.
Inspect multi-sheet Excel files, use Parquet, a column-based file format, for larger datasets, and clean text before analysis. Produce category summaries, identify maximum values, and export formatted reports or scatter plots with fitted straight trend lines.
Analyze numerical data in Excel with box plots and an outlier summary. Extract error values from text containing the ± symbol, chart their distribution, and export statistical results as a CSV report.
Turn Excel or CSV data into an Excel report with category totals, percentage shares, and a doughnut chart. The workflow identifies likely category and numeric columns, cleans missing values, and highlights the largest share.
Clean category and numeric fields in structured data, compare groups with counts and cross-tabulations, and produce charts, Excel results, and a Markdown report. Export visuals as high-resolution PNG and SVG files for use in reports.
Assess numeric Excel columns using IQR, a measure of the middle half of values, to flag outliers. Summarize counts and limits, create box plots, and examine distribution shape to inform data cleaning.
Combine selected columns from multiple Excel sheets, fill blank category cells with the preceding value, and rank records by a chosen metric. Export the top results to an Excel report with headings, borders, and formatted numbers.
Calculate averages for selected groups in Excel and sum items extracted from specified row ranges after removing duplicates. Save filtered records, summary statistics, and item totals as Excel files with local download links.
Analyze Excel data by classifying items, calculating counts and percentages, and comparing categories across groups. Identify values above related limits, then produce a pie chart and an Excel statistics file with download links.
Filter rows from a selected Excel sheet, summarize category counts and percentages, and export the required columns to a new workbook. The workflow also cleans filter values, renames columns, and provides a download link.
Find key figures in tabular data using column names or row keywords, calculate category averages and percentages, and export the results as a structured Excel report and a pie chart.
Prepare large Excel datasets by combining sheets, using Parquet, a format for efficient table storage, and cleaning a selected text column to retain only Chinese characters. Export the cleaned data as an Excel file with a local download link.
Analyze Excel data using custom categories, count distributions, and compare groups with charts. Score text using its length, technical terms, numbers, and selected complex concepts, then visualize difficulty levels and the relationship between text length and scores.
Clean data across multiple Excel sheets, compare totals between sheets, and summarize categories and proportions. Create charts and export a formatted workbook with unusual values highlighted for review.
Count categories in a chosen data column after removing missing values and placeholder labels. Calculate each category’s share and create high-resolution charts combining counts, percentages, pie charts, and horizontal bars for distribution reports.
Is this your account? Link GitHub to bring it onto your creator page (Japanese)