import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import math
df1 = pd.read_excel('Book1.xlsx')
df1
h=df1["Topography"]
distance=df1["Station No."]
FAA=df1["FAA"]
plt.plot(distance,h,'-*r')
plt.title("Topography curve")
fig = plt.figure(figsize=(20,10))
for rho in np.arange(2,3.1,0.1):
c=df1["FAA"]-(0.04192*rho*df1["Topography"])
plt.plot(distance,c,'-*',label="rho{}".format(rho))
plt.legend()
plt.xlabel("station distance")
plt.ylabel("BAA")
fig = plt.figure(figsize=(12,6))
for rho in np.arange(2.4,2.6,0.05):
c=df1["FAA"]-(0.04192*rho*df1["Topography"])
plt.plot(distance,c,"-*",label="rho{}".format(rho))
plt.legend()