import pandas
import numpy
import csv
from matplotlib import pyplot
data = pandas.read_excel("Well.xls")
Depth = data['ГЛУБИНА']
PS = data['ПС']
GK = data['ГК']
DEPTH = data['ГЛУБИНА']
PSmax = numpy.max(PS)
PSmin = numpy.min(PS)
Aps = (PSmax - PS) / (PSmax - PSmin)
Kp = (0.225 * Aps ** 0.516)
i = 0
GK_max = GK[0]
while DEPTH[i] < 3700:
if GK[i] > GK_max:
GK_max = GK[i]
i = i + 1
print (GK)
print(Depth)
print(GK_max)