Csv

#!/bin/bash
# Analyze a CSV file - show structure and statistics

if [ -z "$1" ]; then
    echo "Usage: analyze.sh <csv_file>" >&2
    exit 1
fi

FILE="$1"

if [ ! -f "$FILE" ]; then
    echo "Error: File not found: $FILE" >&2
    exit 1
fi

echo "=== CSV Analysis: $FILE ==="
echo ""

# Row count
TOTAL_ROWS=$(wc -l < "$FILE" | tr -d ' ')
echo "Total rows: $TOTAL_ROWS"

# Column count (from header)
HEADER=$(head -1 "$FILE")
COL_COUNT=$(echo "$HEADER" | awk -F',' '{print NF}')
echo "Columns: $COL_COUNT"

echo ""
echo "=== Header ==="
echo "$HEADER"

echo ""
echo "=== Column Names ==="
echo "$HEADER" | tr ',' '\n' | nl

echo ""
echo "=== First 5 Data Rows ==="
head -6 "$FILE" | tail -5

echo ""
echo "=== Last 3 Data Rows ==="
tail -3 "$FILE"

#!/bin/bash
# Filter CSV rows where a column matches a value

if [ -z "$1" ] || [ -z "$2" ] || [ -z "$3" ]; then
    echo "Usage: filter.sh <csv_file> <column_number> <value>" >&2
    echo "Example: filter.sh data.csv 3 active" >&2
    exit 1
fi

FILE="$1"
COL="$2"
VALUE="$3"

if [ ! -f "$FILE" ]; then
    echo "Error: File not found: $FILE" >&2
    exit 1
fi

# Print header
head -1 "$FILE"

# Filter rows where column matches value
tail -n +2 "$FILE" | awk -F',' -v col="$COL" -v val="$VALUE" '$col == val'

#!/bin/bash
# Select specific columns from a CSV

if [ -z "$1" ] || [ -z "$2" ]; then
    echo "Usage: select.sh <csv_file> <columns>" >&2
    echo "Example: select.sh data.csv 1,3,5" >&2
    exit 1
fi

FILE="$1"
COLS="$2"

if [ ! -f "$FILE" ]; then
    echo "Error: File not found: $FILE" >&2
    exit 1
fi

cut -d',' -f"$COLS" "$FILE"

#!/bin/bash
# Sort CSV by a column

if [ -z "$1" ] || [ -z "$2" ]; then
    echo "Usage: sort.sh <csv_file> <column_number> [--numeric] [--reverse]" >&2
    echo "Example: sort.sh data.csv 2 --numeric --reverse" >&2
    exit 1
fi

FILE="$1"
COL="$2"
shift 2

SORT_OPTS="-t, -k${COL},${COL}"

# Parse options
while [ $# -gt 0 ]; do
    case "$1" in
        --numeric|-n)
            SORT_OPTS="$SORT_OPTS -n"
            ;;
        --reverse|-r)
            SORT_OPTS="$SORT_OPTS -r"
            ;;
    esac
    shift
done

if [ ! -f "$FILE" ]; then
    echo "Error: File not found: $FILE" >&2
    exit 1
fi

# Print header first, then sort the rest
head -1 "$FILE"
tail -n +2 "$FILE" | sort $SORT_OPTS