Untitled

import pandas as pd
import matplotlib.pyplot as plt

# Load the Excel file
file_path = '/path/to/your/excel/file.xlsx'  # Update with your actual file path
sheet_name = 'CHLORO ALKALINE INDICES'

# Read the data from the specified sheet
df = pd.read_excel(file_path, sheet_name=sheet_name)

# Plot CAI-I and CAI-II for each Sample ID
plt.figure(figsize=(10, 6))
plt.plot(df['Sample ID'], df['CAI-I'], marker='o', label='CAI-I', color='b')
plt.plot(df['Sample ID'], df['CAI-II'], marker='o', label='CAI-II', color='g')

# Customize the chart
plt.title('Chloro-Alkaline Indices (CAI-I and CAI-II) Chart')
plt.xlabel('Sample ID')
plt.ylabel('Chloro-Alkaline Indices')
plt.legend()
plt.grid(True)
plt.xticks(rotation=45)

# Show the chart
plt.tight_layout()
plt.show()