데이터·AI 스킬

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.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Removing symbols and numbers from Chinese text columns
• Preparing large Excel datasets for analysis
• Combining sheets and exporting cleaned data

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.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Combine metrics stored on separate Excel sheets
• Fill category gaps caused by merged cells
• Extract the top records by a selected metric

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.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Summarizing data across multiple Excel sheets
• Cleaning merged cells and inconsistent category labels
• Comparing category counts and percentages

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.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Charting monthly changes in category shares
• Comparing composition across groups
• Calculating an Other category from remaining percentages

Clean Excel data, summarize groups, and examine relationships between numeric columns. Produce charts such as scatter plots with trend lines, calculate measures of fit and statistical significance, and export cleaned data and statistical summaries.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Clean missing group labels and numeric text
• Compare group averages and variation
• Analyze numeric relationships with scatter plots and trend lines

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.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Counting rows across every sheet in an Excel workbook
• Calculating category counts and percentages from Parquet data
• Creating a pie chart of category proportions

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 worksheets containing merged cells
• Summarize category counts and percentages
• Compare groups with cross-tabulations

Group Excel figures by department or product line, assign performance tiers, and calculate projections using growth rates set for each tier. Compare current and projected values in charts and summarize overall growth for target setting.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Setting sales targets by department
• Estimating production targets by product line
• Comparing projections under tier-specific growth assumptions

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.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Standardize numerical formats before calculating a column total
• Check detail totals against a summary sheet
• Export reconciliation results to Excel and CSV

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.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Count records containing a specified risk level by work category
• Calculate group shares among matching records
• Summarize large datasets already converted to Parquet

Clean category data in Excel, group entries, and calculate counts, totals, and shares. Create a summary spreadsheet with a total row and highlighted maximum values, alongside a bar chart for comparing groups.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Cleaning category labels before analysis
• Combining labels into defined groups
• Calculating group counts, totals, and shares

Clean categorical Excel data and compare counts and percentage shares across groups. Create cross-tabulation tables, heatmaps that show differences through color, and category rankings, then export the analysis to a workbook with multiple sheets.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Compare award distributions across organizations
• Visualize category shares with a heatmap
• Identify leading groups within each category

Extract text and data from images of charts, tables, interfaces, and diagrams using a vision model, an AI that reads images. Turn the results into structured tables, recreate charts, or export data to Excel and CSV.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Convert a table screenshot into Excel or CSV
• Extract values from a chart and recreate it
• Describe the layout and components of a UI screenshot

Analyze trends and group performance in Excel data, clean percentage values, and calculate projections using growth rates assigned by performance tier. Produce comparison charts and a summary of current totals, projected totals, and growth.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Track changes in business metrics over time
• Compare performance across departments or categories
• Estimate growth using rates assigned by performance tier

Organize Excel analysis from reading multiple sheets through cleaning, filtering, aggregation, and export. Choose processing methods based on row counts, and use supporting skills to produce tables, charts, and Excel or CSV reports.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Clean missing values and inconsistent text in Excel
• Filter and aggregate data across multiple sheets
• Analyze large spreadsheets using row-based processing strategies

Compare counts and shares for two categories in Excel data. The skill cleans the selected columns, calculates differences and percentages, and produces a summary spreadsheet plus bar and pie charts.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Comparing counts for two categories
• Visualizing category shares
• Cleaning merged-cell data before counting

Provide other skills with tools for generating and editing images, analyzing image content, and improving text through external APIs. This foundation passes inputs to backend services without preprocessing and returns results as text or JSON.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Adding image generation to another skill
• Editing reference images with written instructions
• Analyzing the contents of multiple images

Extract key metrics from spreadsheet data, check whether recorded values match calculations after unit conversion, and rank selected metrics from highest to lowest. Export the ranking or validation results to an Excel file for download.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Check calculations involving different units
• Rank business metrics from highest to lowest
• Export validation results to Excel

Analyze Excel datasets totaling at least 10,000 rows using an existing Parquet file, a column-based data format. Extract a chosen metric, identify the category with the highest value, and export an Excel summary with that row highlighted.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Counting rows across multiple Excel sheets
• Extracting a chosen metric from a large dataset
• Finding the category with the highest value

Analyze Excel files with 10,000 or more rows using reading methods suited to their size. Convert data to Parquet, a column-based storage format, reduce memory use, and prepare summaries, charts, or filtered exports.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Summarizing regional sales from 100,000 rows
• Exporting high-value transactions from a million-row log
• Speeding up repeated analysis with Parquet

Extract numbers from text values containing a specified unit, remove unusable rows, and visualize the distribution. Create a histogram with mean and median markers, plus a dashboard showing frequencies, proportions, and cumulative percentages.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Extract numbers from spreadsheet values containing a unit
• Check a distribution against its mean and median
• Compare value frequencies and proportions

Combine selected data from multiple Excel sheets, clean numeric values, and extract the highest entries for a chosen metric. Create a ranked Excel report with highlighted columns, borders, column widths, and number formats for easier comparison.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Extract the top entries for a chosen metric
• Combine selected columns from multiple sheets
• Create a ranked Excel report with highlighted values

Learn from top Kaggle solutions across text, images, time series, tabular data, and multimodal tasks that combine data types. Explore technical analyses, model settings, reusable code templates, and practical lessons to inform machine learning projects.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Study top solutions for a Kaggle competition
• Find proven methods for a machine learning task
• Explore reusable machine learning code templates

Analyze ML and AI experiment results with statistical checks, confidence intervals, and effect sizes, which describe the size of differences. Produce scientific figures and analysis reports while identifying missing evidence and limits on model comparison claims.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Comparing model performance across repeated runs
• Checking significance and the size of performance differences
• Examining how removing model components affects results