Read xls data

import xlrd
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt

df = pd.read_excel('Track_1_Standarddeviation_abbreviated.xls')
for i in df.columns:
    for c in df[i]:
        df[i] = df[i].where(df[i] != 999999.0,np.nan)
        df[i] = df[i].where(df[i] != 0.0,np.nan)




X_row = (df.T).iloc[1:,0]

Y_row = df.iloc[1:, 0]
print(X_row)
print(Y_row)
# X_2d_array, Y_2d_array = np.mgrid
# plt.pcolormesh([X, Y,] C, **kwargs)