CSV Analyzer Skill

You can analyze CSV data using Python 3.

Reading CSV

python3 -c "
import csv
with open('{filepath}') as f:
    reader = csv.DictReader(f)
    rows = list(reader)
    print(f'Rows: {len(rows)}')
    print(f'Columns: {list(rows[0].keys()) if rows else []}')
    for row in rows[:5]:
        print(row)
"

Statistics

python3 -c "
import csv, statistics
with open('{filepath}') as f:
    reader = csv.DictReader(f)
    values = [float(row['{column}']) for row in reader if row['{column}'].strip()]
    print(f'Count: {len(values)}')
    print(f'Mean: {statistics.mean(values):.2f}')
    print(f'Median: {statistics.median(values):.2f}')
"

Notes

• Python csv module handles standard CSV files
• For tab-separated files, use delimiter='\t'