import pandas as pd
# Daten manuell strukturiert
okc_data = [
["Isaiah Hartenstein", 29, "7-8", "0-1", "0-1", 3, 7, 10, 2, 2, 0, 2, 0, "+16", 14],
["Chet Holmgren", 31, "6-8", "0-1", "9-13", 3, 8, 11, 3, 1, 3, 3, 3, "+13", 31],
["Shai Gilgeous-Alexander", 29, "12-17", "2-6", "4-4", 1, 4, 5, 5, 1, 1, 2, 3, "+16", 30],
["Luguentz Dort", 27, "2-7", "1-4", "0-0", 1, 3, 4, 1, 3, 1, 0, 1, "+12", 5],
["Cason Wallace", 26, "1-7", "1-6", "0-0", 1, 2, 3, 3, 1, 0, 1, 3, "+21", 3],
["Jaylin Williams", 18, "3-7", "1-5", "0-0", 0, 3, 3, 0, 0, 0, 2, 2, "+3", 7],
["Brooks Barnhizer", 5, "0-0", "0-0", "0-0", 0, 1, 1, 0, 0, 0, 0, 0, "-5", 0],
["Ousmane Dieng", 20, "0-3", "0-0", "0-0", 0, 2, 2, 6, 2, 0, 1, 1, "+4", 0],
["Branden Carlson", 2, "0-0", "0-0", "0-0", 0, 0, 0, 0, 0, 0, 0, 0, "-1", 0],
["Aaron Wiggins", 27, "4-11", "1-4", "0-0", 4, 1, 5, 2, 0, 0, 3, 3, "+14", 9],
["Chris Youngblood", 11, "2-3", "2-3", "4-4", 0, 1, 1, 0, 0, 0, 0, 0, "+3", 8],
["Ajay Mitchell", 29, "6-14", "0-0", "2-2", 5, 7, 7, 2, 0, 0, 3, 1, "-14", 14],
]
hawks_data = [
["Onyeka Okongwu", 35, "5-12", "1-5", "0-0", 1, 11, 12, 4, 1, 1, 0, 4, "-22", 11],
["Mouhamed Gueye", 23, "4-10", "1-3", "1-3", 2, 4, 6, 2, 0, 2, 1, 4, "-16", 11],
["Trae Young", 34, "3-10", "0-4", "4-4", 0, 4, 4, 10, 0, 0, 5, 2, "-12", 10],
["Nickeil Alexander-Walker", 30, "6-10", "3-6", "2-2", 1, 2, 3, 2, 1, 2, 0, 1, "+8", 17],
["Dyson Daniels", 27, "3-6", "1-1", "1-1", 1, 3, 4, 1, 1, 1, 2, 2, "-12", 8],
["Jacob Toppin", 5, "1-2", "0-0", "0-0", 0, 0, 0, 0, 0, 0, 0, 0, "+6", 2],
["Asa Newell", 25, "4-9", "3-5", "0-0", 7, 3, 10, 1, 0, 0, 2, 5, "-12", 12],
["N'Faly Dante", 9, "0-3", "0-0", "1-1", 2, 2, 4, 0, 0, 0, 0, 0, "+7", 1],
["Luke Kennard", 21, "3-5", "2-3", "0-0", 0, 0, 0, 0, 0, 0, 0, 1, "+14", 8],
["Keaton Wallace", 12, "2-6", "0-2", "1-2", 0, 1, 1, 1, 1, 0, 0, 2, "+1", 5],
["Caleb Houstan", 4, "0-0", "0-0", "0-0", 0, 0, 0, 0, 0, 0, 0, 0, "0", 0],
["Vit Krejci", 22, "4-10", "4-7", "0-0", 1, 1, 2, 1, 1, 0, 3, 4, "+13", 12],
]
columns = ["Player", "MIN", "FG", "3PT", "FT", "OREB", "DREB", "REB", "AST", "STL", "BLK", "TO", "PF", "+/-", "PTS"]
okc_df = pd.DataFrame(okc_data, columns=columns)
hawks_df = pd.DataFrame(hawks_data, columns=columns)
# Excel-Datei mit zwei Tabellenblättern erstellen
with pd.ExcelWriter("NBA_Boxscore_OKC_vs_Hawks.xlsx", engine="xlsxwriter") as writer:
okc_df.to_excel(writer, sheet_name="Oklahoma City Thunder", index=False)
hawks_df.to_excel(writer, sheet_name="Atlanta Hawks", index=False)
print("Excel-Datei erfolgreich erstellt: NBA_Boxscore_OKC_vs_Hawks.xlsx")