# -*- coding: utf-8 -*-
"""
Created on Fri Oct  3 12:47:18 2025

@author: Moritz Romeike
"""

# ------------------------------------------------------------------------
# Programmcode 20 (Python): Scatterplot Preis vs. Lebensdauer
# ------------------------------------------------------------------------
import pandas as pd
import matplotlib.pyplot as plt

# Excel-Datei einlesen (Pfad ggf. anpassen)
data_path = "Kap_4.8.2_dioden_preis_lebensdauer.xlsx"
df_dioden = pd.read_excel(data_path)

# Struktur der Daten prüfen
print(df_dioden.info())
print(df_dioden.head())

# Scatterplot: Preis vs. Lebensdauer
plt.figure(figsize=(7,5))
plt.scatter(df_dioden["Preis (€)"], df_dioden["Lebensdauer (Stunden)"],
            color="blue", s=40, alpha=0.7)

plt.title("Scatterplot: Preis vs. Lebensdauer der Dioden")
plt.xlabel("Preis (€)")
plt.ylabel("Lebensdauer (Stunden)")
plt.grid(True, linestyle="--", alpha=0.6)
plt.tight_layout()
plt.show()
# ------------------------------------------------------------------------