Hw 3- Q3

import xlrd
file_location = "C:/Users/Heena Chotani/Desktop/data.xlsx"
workbook = xlrd.open_workbook(file_location)
sheet = workbook.sheet_by_index(0)
JDdata = () #julian date
Ydata = () #period
TDdata = () #transit duration
PUdata = () #propagation uncertianity
n = () #number of future transits
rows = sheet.nrows
rows = rows - 1
for col in range(sheet.ncols):
if sheet.cell_value(0, col) == 'jd':
for row in range(sheet.nrows):
JDdata = (sheet.cell_value(row, col))
elif sheet.cell_value(0, col) == 'Y':
for row in range(sheet.nrows):
Ydata = (sheet.cell_value(row, col))
elif sheet.cell_value(0, col) == 'TD':
for row in range(sheet.nrows):
TDdata = (sheet.cell_value(row, col))
elif sheet.cell_value(0, col) == 'PU':
for row in range(sheet.nrows):
PUdata = (sheet.cell_value(row, col))
elif sheet.cell_value(0, col) == 'futuretransits':
for row in range(sheet.nrows):
n = (sheet.cell_value(row, col))
Transists = []
in = []
eg = []
ft = JDdata
x = int(n)
td = TDdata
for i in range(x):
Transists.append((ft))
Q = ft+0.5
Z = Q//1
W = ((Z - 1867216.25)/36524.25)//1
B = Z + W - (W/4) + 1525
C = ((B-122.1)/365.25)//1
D = (365.25*C)//1
E = ((B-D)/30.6001)//1
F = (30.6001*E)//1
G = (E/14)//1
Day = B-D-F+(Q-Z)
Month = E-1 - 12*G
Year = C - 4715 - ((7 + Month)/10)//1
time = (Day%1)*24 #hours
print((Day//1), Month, Year, time)
        egress = time - td/2 #hours
        ingress = time + td/2
ft = ft+Ydata
        in.append((ingress))
        eg.append((egress))
     
print(Transists)
print(ingress)
print(egress)



I tested the code with the transit time, Jd, and period of Trappist-1b. I got back similar outputs to those in exoplanet archive.

Comments

Post a Comment

Popular posts from this blog

HW5 Q1 (William Matzko)

Image
1.  For radial velocities, we have the relation k = 28.4 (m/s) p^-(1/3)(M_p*sin(i)) (M_s)^(-2/3), where M_p is the planet mass in Jupiter masses, and M_s is the mass of the star in solar masses. For astrometry, we have  α  = (M_p/M_s)(a)(d)^(-1), where a is the semimajor axis in AU, and d is the distance to the system in parsecs. Just to make things easier to look at, we can make some simplifying assumptions. We are already told to assume sin(i) = 1 in all instances and M_s is the mass of the Sun. We might as well further assume that our target is one Jupiter mass. Further, we know P is proportional to a ^(3/2). The two above equations then reduce to α = 0.001 (a) (d)^-1 k = 28.4 (m/s) (a)^(-1/2) We are given that astrometry is sensitive to  α = 10 micro arcseconds and above, and radial velocities are sensitive to k = 1 m/s and above. Note that only the astrometry method depends on d. We must now find when the astrometry method becomes more sensitive than the rad...
Read more

HW5 Q2, Q3, Q5 (William Matzko)

2. We know the phase amplitude is  ε = A*g*(R/r)^2, where A is the geometric albedo, R is the radius of the planet, r = a(1-e^2)/(1+ecos(f)), and g = 10^(-0.4*m). Here, m is just  m = 0.09( α/100) + 2.39( α/100)^2 - 0.65( α/100), where  α is in degrees (the 100's in the denominator are likewise in degrees). We are working with a Venus analog, so we can assume, in this part, that e = 0, so that r = a. The phase amplitude will be maximum when  α = 0. So, our maximum phase amplitude is then  ε = (0.67) (1)(6050km/108E6km)^2, where I have plugged in the geometric albedo of Venus, the radius of Venus, and Venus' semimajor axis. This yeilds  ε = 2E-9.  Now, we are to assume i = 40 degrees and w = 270 degrees. The effect of w is to orient the orbit such that we have a maximum phase angle at f = 0 . We know the relation between  α and these orbital elements: cos( α) = -sin(i)sin(w+f). Plugging in the numbers and solving for  α yields  α = 50 d...
Read more

HW 5 Q6 (William Matzko)

6. (a)Usually, the temperature on a planet decreases with altitude. However, in inversion layers, this is not the case. In an inversion layer, temperature increases with altitude. Such a thing is important in the atmosphere of exoplanets because it can give insight into what that planet's atmosphere could be composed of. These inversion layers are usually composed of molecules that absorb UV radiation, so finding these inversion layers on exoplanets is desirable if we want to try and find life on them. (b) We know that P = P_0 exp(-z/H), where P is the pressure, P_0 is the pressure at the surface level, z is the altitude above surface level and H is the scale height. We are given that, on Earth z = 8.8 km and H = 8 km. This corresponds to a pressure of ~0.333*P_0. On a modified planet, to find the z at which we have the same pressure, we first must compute the scale height. We can express the scale height equation as H = k*T/(u*m*g), where k is the Boltzmann constant, T is the te...
Read more