import matplotlib.pyplot as plt
import pandas as pd
 
file = 'eiendom.xlsx'
data = pd.read_excel(file) #reading file

#print(data)

nom = data['Nominell indeks'].values

plt.close('all')
plt.plot(nom)
plt.xlabel('Mnd fra januar 2003')
plt.ylabel('Nominell indeks')
plt.grid()
# plt.savefig('plott_nominell_indeks.pdf')
plt.show()

dato = data['Month of Dato'].values

val = 193.5
for i in range(0, len(nom), 1):
    if (nom[i] >= val):
        elm = i
        break

print('Nominell indeks naar', val, 'i', dato[elm])