We are going to import the file we used last time, but we also want to fill in the NaN values. Using fillna() we can decide what we want the NaN values to be, in our case it will be 0.

import pandas as pd
df = pd.DataFrame.from_csv("RegressionMatrix1.csv",encoding="UTF-8")
df = df.fillna(0)
print(df)

We also want a different orientation where the beta indicators are the columns. For that, we need to transpose the dataframe.

df = df.transpose()
print(df)

Now, we need to deal with the data. What we are going to use is the z-score for each value. What the z-score is, is a measure that says how many standard deviations a value is away from the mean. So we want to get the value minus the mean, and divide that by the column standard deviation.