🐍 Python Programme & Scripte

#!/usr/bin/env python3
import pandas as pd

def analyze_dataset(file_path):
    print("📊 Lade Datensatz...")
    df = pd.read_csv(file_path) if file_path.endswith(".csv") else pd.read_excel(file_path)
    
    # Daten-Bereinigung & Filter
    df_clean = df.drop_duplicates().dropna(subset=["title", "downloads"])
    
    # Aggregation & KPIs
    total_downloads = df_clean["downloads"].sum()
    top_items = df_clean.nlargest(5, "downloads")[["title", "downloads"]]
    
    print(f"Gesamt Downloads: {total_downloads}")
    print("\n🏆 Top 5 Projekte:")
    print(top_items.to_string(index=False))
    
    # Export bereinigter Bericht
    df_clean.to_excel("bereinigter_bericht.xlsx", index=False)
    print("✅ Export gespeichert als: bereinigter_bericht.xlsx")