ApJdataFrames Muzic2014Title: SUBSTELLAR OBJECTS IN NEARBY YOUNG CLUSTERS (SONYC). VIII. SUBSTELLAR POPULATION IN LUPUS 3
Authors: Muzic et al.
Data is from this paper:
http://iopscience.iop.org/0004-637X/785/2/159/article#apj492858t1
In [4]:
%pylab inline
import seaborn as sns
sns.set_context("notebook", font_scale=1.5)
#import warnings
#warnings.filterwarnings("ignore")
Populating the interactive namespace from numpy and matplotlib
In [5]:
import pandas as pd
Internet is still not working
In [21]:
tbl2 = pd.read_clipboard(#"http://iopscience.iop.org/0004-637X/785/2/159/suppdata/apj492858t2_ascii.txt",
sep='\t', skiprows=[0,1,2,4], skipfooter=7, engine='python', na_values=" sdotsdotsdot", usecols=range(15))
tbl2.rename(columns={"Unnamed: 6": "Av_phot", "Unnamed: 8":"Av_spec"}, inplace=True)
tbl2
Out[21]:
ID
alpha(J2000)
delta(J2000)
i
J
K
Av_phot
SpT
Av_spec
mu_alphacos delta
mu_delta
mu -
EW(Halpha)
Membership
Comments
0
S-1
16:07:08.55
-39:14:07.8
17.3
14.6
11.5
11.5
M 1.75
3.0
-4.2 +or- 5.2
-21.2 +or- 4.7
y
-77.6
Lupus 3
M08
1
S-2
16:07:33.82
-39:03:26.5
19.4
16.2
14.1
6.0
M 3.00
5.0
0.4 +or- 7.1
-16.3 +or- 5.9
y
-4.9
uncertain
NaN
2
S-3
16:07:55.18
-39:06:04.0
16.2
13.5
11.4
5.9
M 5.75
2.0
-12.4 +or- 7.1
-22.8 +or- 5.9
y
-37.2
Lupus 3
M6.5^d, C09, G06
3
S-4
16:08:04.76
-39:04:49.6
17.0
13.9
12.4
2.9
M 6.50
1.0
-8.1 +or- 7.1
-22.6 +or- 5.9
y
-44.4
Lupus 3
M7^d, C09
4
S-5
16:08:16.03
-39:03:04.5
15.5
12.5
11.1
2.5
M 6.25
1.0
-9.3 +or- 7.1
-19.9 +or- 5.9
y
-37.5
Lupus 3
Par-Lup3-1; M7.5^a, M5.5^b
5
S-6
16:08:59.52
-38:56:20.8
19.1
17.4
16.7
0.0
M 4.75
0.0
-6.5 +or- 7.1
-19.4 +or- 5.9
y
-18.6
uncertain
NaN
6
S-7
16:08:59.53
-38:56:27.8
17.1
13.9
12.7
1.3
M 8.00
0.5
-8.8 +or- 7.1
-19.6 +or- 5.9
y
-185.7
Lupus 3
M8^c, G06
7
S-8
16:10:18.13
-39:10:33.6
19.8
16.2
13.8
7.3
M 1.00
6.5
-16.2 +or- 5.3
-9.8 +or- 5.0
y
-4.6
uncertain
NaN
8
S-9
16:11:26.34
-39:02:17.1
19.3
16.2
14.0
6.4
M 1.00
5.5
-14.6 +or- 5.3
-11.3 +or- 5.0
y
NaN
uncertain
NaN
9
S-10
16:09:13.43
-38:58:04.9
19.5
16.1
14.9
1.5
M 8.75
0.0
-13.8 +or- 7.1
-20.9 +or- 5.9
y
-48.8
Lupus 3
NaN
10
S-11
16:12:05.91
-39:04:07.5
18.7
15.7
14.4
1.5
M 3.00
3.0
-24.7 +or- 5.3
-20.5 +or- 5.0
y
-5.4
uncertain
NaN
11
S-12
16:11:18.47
-39:02:58.2
18.0
15.1
13.3
4.2
<M 1
NaN
-6.1 +or- 5.3
-8.5 +or- 5.0
y
-12.1
Lupus 3
NaN
12
S-13
16:07:36.48
-39:04:53.8
15.7
12.9
10.6
7.1
M 0.00
3.5
-3.4 +or- 7.1
1.1 +or- 5.9
n
NaN
III^2
NaN
13
S-14
16:08:01.42
-39:10:16.1
19.9
16.4
14.0
7.7
<M 1
NaN
-8.4 +or- 7.1
-12.7 +or- 5.9
y
NaN
uncertain
NaN
14
S-15
16:07:52.46
-39:09:48.1
19.0
15.6
13.2
7.6
M 2.50
4.7
-29.8 +or- 7.1
-23.1 +or- 5.9
y
NaN
V^3
NaN
15
S-16
16:10:14.95
-39:10:16.2
19.9
16.4
14.3
5.7
M 4.50
4.7
5.9 +or- 5.3
24.0 +or- 5.0
n
NaN
V
NaN
16
S-17
16:11:56.11
-39:08:23.8
15.3
12.8
11.1
4.2
<M 1
NaN
-0.3 +or- 5.3
11.1 +or- 5.0
n
NaN
III
NaN
17
S-18
16:11:09.03
-39:06:22.7
16.8
14.3
12.5
4.5
M 2.50
3.0
-11.4 +or- 5.3
-21.7 +or- 5.0
y
NaN
V
NaN
18
S-19
16:11:39.24
-39:06:32.8
15.4
12.5
10.4
6.0
M 0.50
3.0
-5.7 +or- 5.3
-5.4 +or- 5.0
y
NaN
III
NaN
19
S-20
16:11:36.20
-39:02:36.9
20.4
16.8
14.6
6.9
M 4.00
5.3
3.9 +or- 5.3
17.1 +or- 5.0
n
NaN
V
NaN
20
S-21
16:11:33.34
-38:59:44.3
19.9
16.5
14.3
4.9
M 3.00
4.5
7.8 +or- 5.3
1.1 +or- 5.0
n
NaN
V
NaN
21
S-22
16:10:47.49
-38:57:12.4
20.4
17.1
16.2
0.0
<M 1
NaN
NaN
NaN
NaN
NaN
uncertain
NaN
22
S-23
16:10:45.40
-38:54:54.9
16.1
14.3
12.9
2.1
<M 1
NaN
-7.9 +or- 5.3
-1.9 +or- 5.0
n
NaN
III
M08, C09
23
S-24
16:07:09.06
-39:01:07.6
19.8
18.1
16.6
2.8
M 1.50
1.5
7.4 +or- 5.2
3.6 +or- 4.7
n
NaN
V
NaN
24
S-25
16:12:04.96
-39:06:11.4
19.9
17.9
16.0
5.1
M 2.50
3.0
1.0 +or- 5.3
2.7 +or- 5.0
n
NaN
V
NaN
25
S-26
16:10:56.40
-39:04:31.7
19.1
17.3
15.7
3.4
M 5.0
2.5
35.4 +or- 5.3
0.9 +or- 5.0
n
NaN
V
NaN
26
S-27
16:11:15.08
-39:07:15.0
18.1
16.4
14.7
3.6
M 7.0
0.0
NaN
NaN
NaN
NaN
V
NaN
In [22]:
! mkdir ../data/Muzic2014
In [24]:
tbl2.to_csv("../data/Muzic2014/tbl2.csv", index=False)
In [28]:
tbl4 = pd.read_clipboard(#"http://iopscience.iop.org/0004-637X/785/2/159/suppdata/apj492858t4_ascii.txt",
sep='\t', skiprows=[0,1,2,4], skipfooter=2, engine='python', na_values=" sdotsdotsdot", usecols=range(8))
tbl4
Out[28]:
ID
alpha
delta
J
K
SpT
T_eff
Other Names
0
SONYC-Lup3-1
16 07 08.55
-39 14 07.8
14.6
11.5
M1.75^a
3850^a, 4400^b
NaN
1
SONYC-Lup3-3
16 07 55.18
-39 06 04.0
13.5
11.4
M 5.75^a, M6.5^c
3050^a, 2900^b, 2950^c
NaN
2
SONYC-Lup3-4
16 08 04.76
-39 04 49.6
13.9
12.4
M 6.50^a, M7^c
3000^a, 2700^b, 2900^c
NaN
3
SONYC-Lup3-5
16 08 16.03
-39 03 04.5
12.5
11.1
M 6.25^a, M7.5^d,M5.5^g
2950^a, 2800^b
Par-Lup3-1
4
SONYC-Lup3-7
16 08 59.53
-38 56 27.8
13.9
12.7
M 8.00^a, e, M8.5^h
2850^a, 2600^b, h
NaN
5
SONYC-Lup3-10
16 09 13.43
-38 58 04.9
16.1
14.9
M 8.75^a
2650^a
NaN
6
SONYC-Lup3-12
16 11 18.47
-39 02 58.2
15.1
13.3
<M 1^a
4200^a
NaN
7
EX Lup
16 03 05.5
-40 18 26
9.7
8.5
M0^f
NaN
HD 325367, Th 14
8
Sz-88
16 07 00.61
-39 02 19.9
9.9
8.6
M1^f, M0^h
3850^h
Th 15
9
Sz-91
16 07 11.57
-39 03 47.2
11.1
9.8
M0.5^f, M1^h
3705^h
Th 20
10
Sz-94
16 07 49.68
-39 04 28.6
11.4
10.6
M4^f, M4.5^g
NaN
NaN
11
Sz-95
16 07 52.29
-38 58 05.6
11.0
10.0
M1.5^f
NaN
NaN
12
Sz-96
16 08 12.48
-39 08 33.0
10.1
9.0
M1.5^f,M2^g
3560^g
NaN
13
Sz-97
16 08 21.84
-39 04 21.4
11.2
10.2
M3^f,M4.5^g, M4^h
3198^g, 3270^h
Th 24
14
Sz-98
16 08 22.44
-39 04 46.7
9.5
8.0
M0^f
NaN
NaN
15
Sz-99
16 08 24.00
-39 05 49.2
11.9
10.7
M3.5^f,M4^g, h
3270^g, h
Th 25
16
Sz-100
16 08 25.76
-39 06 01.2
11.0
9.9
M5^d, f, M4.5^g, M5.5^h
3198^g, 3057^h
Th 26
17
Sz-101
16 08 28.37
-39 05 32.3
10.4
9.4
M4.5^g,M4^f
3198^g
Th 27
18
Sz-103
16 08 30.24
-39 06 10.8
11.4
10.2
M4^f, h, M4.5^g
3198^g, 3270^h
Th 29
19
Sz-104
16 08 30.72
-39 05 48.5
11.7
10.7
M5^f, h,M5.5^g
3058^g, 3125^h
Th 30
20
Sz-105
16 08 37.03
-40 16 20.8
9.0
7.6
M4^f
NaN
Th 31
21
Sz-106
16 08 39.76
-39 06 25.3
11.7
10.1
M0^f,M2.5^d, M0.5^h
3777^h
NaN
22
Sz-107
16 08 41.76
-39 01 36.8
11.2
10.3
M5.5^f, M6.5^g
2935^g
NaN
23
Sz-108A
16 08 42.74
-39 06 18.4
9.8
8.8
M3^d
NaN
NaN
24
Sz-108B
16 08 42.87
-39 06 14.6
NaN
NaN
M6^d, M5.5^g
3058^g
NaN
25
Sz-109
16 08 48.16
-39 04 19.3
11.4
10.5
M5.5^f, M6.5^d
NaN
NaN
26
Sz-110
16 08 51.57
-39 03 17.7
11.0
9.7
M4.5^d, M3^g, M2^f,M4^h
3415^g, 3270^h
Th 32
27
Sz-111
16 08 54.74
-39 37 43.6
10.6
9.5
M1.5^f, M1^h
3705^h
Th 33
28
Sz-112
16 08 55.53
-39 02 34.0
11.0
10.0
M4^f,M6^d, M5^h
3125^h
NaN
29
Sz-113
16 08 57.80
-39 02 22.8
12.5
11.3
M4^f, M6^d, M1.5^g, M4.5^h
3633^g, 3197^h
Th 34, Lup 609s
...
...
...
...
...
...
...
...
...
52
M-24
16 07 58.80
-39 24 34.9
12.6
11.6
M6^g
NaN
Lup 714
53
M-25
16 11 51.12
-38 51 05.0
13.3
12.3
M5.5^g
NaN
Lup 802s
54
M-27
16 09 56.40
-38 59 51.0
13.0
12.0
M6^g, h
2990^g, h
Lup 818s
55
M-51
16 11 59.76
-38 23 38.4
12.2
11.2
M6^g, M5^h
2990^g, 3125^h
SST-Lup3-1
56
M-58
16 07 03.84
-39 11 11.4
14.7
13.1
M5.5^g
3058^g
NaN
57
M-62
16 09 01.44
-39 25 12.0
11.6
10.3
M3.5^g, M4^h
3343^g, 3270^h
NaN
58
M-65
16 10 12.96
-38 46 16.3
15.9
13.9
M4^g
3270^g
NaN
59
M-66
16 10 19.92
-38 36 06.5
13.3
12.3
M6^g
2990^g
NaN
60
M-67
16 10 29.52
-39 22 14.5
11.9
10.9
M5.5^g
3058^g
NaN
61
M-69
16 11 31.92
-38 11 10.0
12.3
10.7
M2.5^g
3488^g
NaN
62
M-70
16 11 44.88
-38 32 44.9
12.4
11.5
M6.5^g
2935^g
NaN
63
J16052862-3846210
16 05 28.63
-38 46 21.1
12.6
11.8
M6^c
3000^c
NaN
64
J16083304-3852224
16 08 33.05
-38 52 22.4
12.9
11.9
M7.5^c
2800^c
NaN
65
J16083547-3900358
16 08 35.48
-39 00 35.8
11.5
10.6
M6.5^c
2950^c
NaN
66
J16083974-3929228
16 08 39.75
-39 29 22.9
11.7
10.9
M5^c
3100^c
NaN
67
J16085575-3826330
16 08 55.75
-38 26 33.1
13.0
12.1
M5.5^c
3050^c
NaN
68
J16090452-3921125
16 09 04.52
-39 21 12.5
10.7
9.8
M5^c
3100^c
NaN
69
J16091570-3851396
16 09 15.71
-38 51 39.7
12.0
11.2
M5^c
3100^c
NaN
70
J16092279-3855506
16 09 22.80
-38 55 50.6
10.8
9.9
M5^c
3100^c
J160922.8-385550A^c
71
J16092320-3855547
16 09 23.20
-38 55 54.8
10.8
9.9
M4^c
3250^c
J160922.8-385550B^c
72
J16092800-3848538
16 09 28.01
-38 48 53.8
11.9
11.0
M5.5^c
3050^c
NaN
73
J16101386-3759589
16 10 13.87
-37 59 58.9
12.2
11.2
M6^c
3000^c
NaN
74
J16103062-3831517
16 10 30.62
-38 31 51.7
13.3
12.4
M6^c
3000^c
NaN
75
J16103323-3830234
16 10 33.23
-38 30 23.5
10.8
9.8
M4.5^c
3200^c
NaN
76
J16104192-3823046
16 10 41.92
-38 23 04.7
10.9
10.0
M5^c
3100^c
NaN
77
J16105899-3914514
16 10 58.99
-39 14 51.4
12.1
11.3
M5^c
3100^c
NaN
78
J16113801-3841356
16 11 38.02
-38 41 35.7
10.9
10.1
M2.5^c
3500^c
NaN
79
J16120761-3813242
16 12 07.61
-38 13 24.3
10.9
10.0
M4.5^c
3200^c
NaN
80
J16121046-3909040
16 12 10.46
-39 09 04.0
13.9
12.8
M6.5^c
2950^c
NaN
81
J16122559-3817428
16 12 25.58
-38 17 42.8
13.1
12.2
M6^c
3000^c
NaN
82 rows × 8 columns
In [29]:
tbl4.to_csv("../data/Muzic2014/tbl4.csv", index=False)
Script finished.
Content source: BrownDwarf/ApJdataFrames
Similar notebooks: