import pandas as pd # Load the Excel file file_path = r"path to\VanillaCVDM_all_metrics.xlsx" # Replace with your file path df = pd.read_excel(file_path, header=None) # Set the first row as column headers df.columns = df.iloc[0] df = df[1:] # Remove the first row from the data # # Debugging: Check the processed data # print("\nProcessed DataFrame:") # print(df.head()) # Calculate the Pearson correlation coefficient matrix correlation_matrix = df.corr(method='pearson').round(3) # Display the correlation matrix print("\nPearson Correlation Coefficient Matrix:") print(correlation_matrix) # Optionally, save the correlation matrix to a CSV file #correlation_matrix.to_csv(r"path to\VanillaCVDM_correlation_matrix.csv", index=True)