In [25]:
from astropy.table import Table
from basicio import io
import pandas as pd

In [2]:
fname = 'basicio/example_data/table_data.dat'
data = io.file2strarray(fname)

In [3]:
a =  io.strarray2recarray(data)

In [4]:
varstring = 'ID z zERR x0 x0ERR c cERR x1 x1ERR PKMJD PKMJDERR mB mBERR COVx0x1 COVx0c COVx1c CHI2 NDOF FITPROB SNRMAX1 SNRMAX2 SNRMAX3 IDSURVEY TYPE MWEBV TrestMIN TrestMAX'
varnames = varstring.split()
print varnames


['ID', 'z', 'zERR', 'x0', 'x0ERR', 'c', 'cERR', 'x1', 'x1ERR', 'PKMJD', 'PKMJDERR', 'mB', 'mBERR', 'COVx0x1', 'COVx0c', 'COVx1c', 'CHI2', 'NDOF', 'FITPROB', 'SNRMAX1', 'SNRMAX2', 'SNRMAX3', 'IDSURVEY', 'TYPE', 'MWEBV', 'TrestMIN', 'TrestMAX']

In [5]:
a.dtype.names = varnames

In [7]:
Table(a)


Out[7]:
<Table length=96>
IDzzERRx0x0ERRccERRx1x1ERRPKMJDPKMJDERRmBmBERRCOVx0x1COVx0cCOVx1cCHI2NDOFFITPROBSNRMAX1SNRMAX2SNRMAX3IDSURVEYTYPEMWEBVTrestMINTrestMAX
str20float32float32float32float32float32float32float32float32float32float32float32float32float32float32float32float32int64float32float32float32float32int64int64float32float32float32
67730.08930.00050.000816976.28e-05-0.07280.02790.09040.156253678.50.1418.35450.0804-1.15e-06-1.34e-060.000758221.0311.53e-3049.3549.3529.3311200.1366-9.5326922.5507
171860.07850.00.000467741.76e-050.1010.02480.57370.16854353.80.2218.960.04-1.11e-06-2.99e-075.74e-0549.4360.067451.6937.4336.1811200.0351-6.8565439.3515
03D3ba0.29120.0013.8536e-051.48e-060.10260.03790.75650.158452749.30.4421.67030.041-6.07e-09-4.38e-08-0.0011717.590.0409139.58120.6811.47400.0128-14.571536.5135
04D1ow0.9150.0014.3024e-061.79e-07-0.17050.0489-0.01460.336853311.70.3824.05070.0442-3.04e-081.72e-090.0044545.5440.40828.919.5612.21400.0265-13.144141.0294
04D3nq0.220.0019.1867e-052.39e-06-0.01410.02520.57580.104253189.80.120.72710.0279-5.89e-08-4.57e-08-7.45e-055.5180.998445.11414.43287.94400.0097-11.857431.5212
06D3em0.690.0014.0938e-061.3e-070.15670.04570.01390.369653881.70.5524.10470.034-2.06e-08-8.55e-100.002334.3410.76122.1119.8513.18400.0105-13.26936.442
04D2al0.8360.0014.3415e-062.85e-07-0.10710.0887-1.22291.015153034.41.3724.04090.0695.34e-081.16e-080.05879.1130.76622.8119.111.67400.017-7.0407943.5149
04D1qd0.7670.0014.6575e-061.44e-070.03340.05090.2740.272253329.50.3823.96460.0332-1.77e-08-1.1e-090.0033632.5320.44224.5515.5715.27400.028-10.257934.4108
05D4hn0.8420.0014.8893e-062.38e-070.07370.07051.43880.828953693.90.7923.91190.0515-1.31e-07-2.41e-090.02714.1180.72527.218.3613.55400.0287-15.02568.2974
06D3en1.060.0013.1053e-062.38e-07-0.1810.0577-1.08710.380353881.60.8624.40480.0802-2.56e-087.96e-090.0055728.1350.79114.428.836.33400.0111-14.727629.9383
.................................................................................
05D3gp0.580.0019.1772e-064.31e-07-0.08540.0458-0.5630.415853454.90.3623.22820.0498-1.41e-07-8.38e-090.0071842.7410.39927.7316.289.49400.0088-9.0915943.9222
03D1co0.6790.0015.4032e-062.25e-07-0.0580.04670.75540.417452954.40.423.80340.0443-6.53e-08-2.53e-090.0064941.9430.5223.120.377.7400.0299-14.877942.8341
04D2fp0.4150.0012.2215e-055.66e-07-0.04810.0270.33580.145453107.40.1822.26840.0273-2.69e-08-9.48e-09-9.33e-0519.5170.368.1365.7637.19400.0197-9.926130.986
04D4fx0.6290.0019.0283e-062.69e-07-0.00720.0350.97370.235753242.50.2423.2460.0319-3.72e-08-3.15e-090.0010449.7430.22351.8141.6616.06400.028-11.013744.6762
05D4be0.5370.0011.6136e-054.12e-07-0.16320.02741.04740.165253551.50.2322.61550.0274-2.6e-08-5.45e-090.00017383.6510.0026859.6155.7152.52400.0282-14.259342.8909
06D2ga0.840.0014.4516e-063.31e-07-0.02560.07631.68141.083653869.20.8724.01370.0779-2.61e-07-2.59e-090.03811.3130.58419.6212.977.14400.0198-11.37429.26739
05D3mn0.760.0015.6671e-061.43e-07-0.0260.04850.11840.29853559.30.3623.75160.0271-1.16e-08-1.36e-100.0022219.8180.34458.5235.2915.49400.0089-14.225315.2935
05D2ct0.7340.0014.133e-062.2e-070.09690.05660.32540.499253425.20.4724.09430.0564-8.21e-08-1.98e-090.0076539.8310.13419.7714.617.42400.0177-9.6533240.4679
05D2by0.8910.0013.4904e-061.61e-07-0.01480.05841.52660.541353413.10.7724.27780.0488-3.17e-083.27e-090.0066324.7310.78326.0814.4611.21400.0177-14.585643.4793
04D1sa0.5850.0018.7514e-062.78e-07-0.08340.0337-0.52370.303753360.20.3323.27980.034-4.63e-08-3.32e-090.0023227.9230.21939.7137.1923.96400.0252-11.207618.9507

In [9]:
io.arraydtypes(data)


Out[9]:
dtype([('f0', 'S20'), ('f1', '<f4'), ('f2', '<f4'), ('f3', '<f4'), ('f4', '<f4'), ('f5', '<f4'), ('f6', '<f4'), ('f7', '<f4'), ('f8', '<f4'), ('f9', '<f4'), ('f10', '<f4'), ('f11', '<f4'), ('f12', '<f4'), ('f13', '<f4'), ('f14', '<f4'), ('f15', '<f4'), ('f16', '<f4'), ('f17', '<i8'), ('f18', '<f4'), ('f19', '<f4'), ('f20', '<f4'), ('f21', '<f4'), ('f22', '<i8'), ('f23', '<i8'), ('f24', '<f4'), ('f25', '<f4'), ('f26', '<f4')])

In [10]:
import numpy as np

In [11]:
np.core.rec.fromrecords(fname, dtype=io.arraydtypes(data))


Out[11]:
rec.array(('basicio/example_data', 1.0397223317042385e+21, 1.6483728578930182e+22, 5.126244220776677e-11, 1.0687854727639527e-38, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0, 0.0, 0.0, 0.0, 0.0, 0, 0, 0.0, 0.0, 0.0), 
          dtype=[('f0', 'S20'), ('f1', '<f4'), ('f2', '<f4'), ('f3', '<f4'), ('f4', '<f4'), ('f5', '<f4'), ('f6', '<f4'), ('f7', '<f4'), ('f8', '<f4'), ('f9', '<f4'), ('f10', '<f4'), ('f11', '<f4'), ('f12', '<f4'), ('f13', '<f4'), ('f14', '<f4'), ('f15', '<f4'), ('f16', '<f4'), ('f17', '<i8'), ('f18', '<f4'), ('f19', '<f4'), ('f20', '<f4'), ('f21', '<f4'), ('f22', '<i8'), ('f23', '<i8'), ('f24', '<f4'), ('f25', '<f4'), ('f26', '<f4')])

In [12]:
aa = np.zeros(len(data), dtype=io.arraydtypes(data))

In [13]:
aa[0] = a[0]

In [14]:
aa.dtype


Out[14]:
dtype([('f0', 'S20'), ('f1', '<f4'), ('f2', '<f4'), ('f3', '<f4'), ('f4', '<f4'), ('f5', '<f4'), ('f6', '<f4'), ('f7', '<f4'), ('f8', '<f4'), ('f9', '<f4'), ('f10', '<f4'), ('f11', '<f4'), ('f12', '<f4'), ('f13', '<f4'), ('f14', '<f4'), ('f15', '<f4'), ('f16', '<f4'), ('f17', '<i8'), ('f18', '<f4'), ('f19', '<f4'), ('f20', '<f4'), ('f21', '<f4'), ('f22', '<i8'), ('f23', '<i8'), ('f24', '<f4'), ('f25', '<f4'), ('f26', '<f4')])

In [15]:
aa['f0']


Out[15]:
array(['6773', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '',
       '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '',
       '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '',
       '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '',
       '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '',
       '', '', '', '', '', '', '', '', '', '', '', ''], 
      dtype='|S20')

In [17]:
dt = io.arraydtypes(data)

In [18]:
aaa = np.array([('s0', 2.3),('s1', 3.4)], dtype=np.dtype([('mystring', 'S20'), ('myval', '<f4')]))

In [19]:
aaa.dtype


Out[19]:
dtype([('mystring', 'S20'), ('myval', '<f4')])

In [20]:
dd = np.format_parser(formats=['S20','<f4'], names=['mystring', 'myval'], titles=None)

In [21]:
print dd.dtype


[('mystring', 'S20'), ('myval', '<f4')]

In [22]:
aaaa = np.array([('s0', 2.3),('s1', 3.4)], dtype=dd)

In [23]:
aaaa.dtype


Out[23]:
dtype([('mystring', 'S20'), ('myval', '<f4')])

In [26]:
df = pd.DataFrame(a)

In [27]:
df


Out[27]:
ID z zERR x0 x0ERR c cERR x1 x1ERR PKMJD ... NDOF FITPROB SNRMAX1 SNRMAX2 SNRMAX3 IDSURVEY TYPE MWEBV TrestMIN TrestMAX
0 6773 0.0893 0.0005 0.000817 6.280000e-05 -0.0728 0.0279 0.0904 0.1562 53678.492188 ... 31 1.530000e-30 49.349998 49.349998 29.330000 1 120 0.1366 -9.532692 22.550652
1 17186 0.0785 0.0000 0.000468 1.760000e-05 0.1010 0.0248 0.5737 0.1680 54353.808594 ... 36 6.740000e-02 51.689999 37.430000 36.180000 1 120 0.0351 -6.856541 39.351463
2 03D3ba 0.2912 0.0010 0.000039 1.480000e-06 0.1026 0.0379 0.7565 0.1584 52749.304688 ... 9 4.090000e-02 139.580002 120.680000 11.470000 4 0 0.0128 -14.571482 36.513504
3 04D1ow 0.9150 0.0010 0.000004 1.790000e-07 -0.1705 0.0489 -0.0146 0.3368 53311.710938 ... 44 4.080000e-01 28.900000 19.559999 12.210000 4 0 0.0265 -13.144104 41.029362
4 04D3nq 0.2200 0.0010 0.000092 2.390000e-06 -0.0141 0.0252 0.5758 0.1042 53189.792969 ... 18 9.980000e-01 445.109985 414.429993 287.940002 4 0 0.0097 -11.857417 31.521168
5 06D3em 0.6900 0.0010 0.000004 1.300000e-07 0.1567 0.0457 0.0139 0.3696 53881.734375 ... 41 7.610000e-01 22.110001 19.850000 13.180000 4 0 0.0105 -13.269043 36.442032
6 04D2al 0.8360 0.0010 0.000004 2.850000e-07 -0.1071 0.0887 -1.2229 1.0151 53034.406250 ... 13 7.660000e-01 22.809999 19.110001 1.670000 4 0 0.0170 -7.040792 43.514935
7 04D1qd 0.7670 0.0010 0.000005 1.440000e-07 0.0334 0.0509 0.2740 0.2722 53329.503906 ... 32 4.420000e-01 24.549999 15.570000 15.270000 4 0 0.0280 -10.257948 34.410809
8 05D4hn 0.8420 0.0010 0.000005 2.380000e-07 0.0737 0.0705 1.4388 0.8289 53693.945312 ... 18 7.250000e-01 27.200001 18.360001 13.550000 4 0 0.0287 -15.025583 8.297401
9 06D3en 1.0600 0.0010 0.000003 2.380000e-07 -0.1810 0.0577 -1.0871 0.3803 53881.648438 ... 35 7.910000e-01 14.420000 8.830000 6.330000 4 0 0.0111 -14.727606 29.938278
10 03D4ag 0.2850 0.0010 0.000071 2.280000e-06 -0.0707 0.0242 0.9014 0.1468 52830.800781 ... 25 9.190000e-01 225.470001 141.550003 112.269997 4 0 0.0258 -14.187397 43.266399
11 06D4co 0.4370 0.0010 0.000023 5.440000e-07 -0.0505 0.0229 -0.3482 0.1050 53940.210938 ... 45 3.490000e-01 99.959999 99.230003 70.120003 4 0 0.0259 -13.716855 41.878567
12 05D3dd 0.4800 0.0010 0.000015 3.720000e-07 -0.0441 0.0243 -0.2359 0.1284 53455.230469 ... 43 6.550000e-01 103.370003 62.849998 57.770000 4 0 0.0094 -9.932400 43.316650
13 04D1ak 0.5260 0.0010 0.000008 3.740000e-07 0.0200 0.0573 -1.8138 0.3298 53010.507812 ... 15 7.430000e-01 34.369999 31.290001 5.950000 4 0 0.0256 -13.266509 10.375774
14 06D4dh 0.3030 0.0010 0.000061 1.650000e-06 -0.1547 0.0220 0.5019 0.0804 53956.800781 ... 37 2.530000e-01 208.380005 151.919998 138.460007 4 0 0.0262 -13.290909 33.455181
15 03D3bh 0.2486 0.0010 0.000087 5.090000e-06 -0.3774 0.0317 -5.0000 0.0331 52783.242188 ... 8 1.230000e-07 90.720001 81.550003 60.770000 4 0 0.0101 5.730796 27.298702
16 05D4cn 0.7630 0.0010 0.000005 1.660000e-07 0.0064 0.0525 1.1467 0.2677 53583.511719 ... 49 2.660000e-04 41.200001 25.730000 13.090000 4 0 0.0259 -14.175700 40.168369
17 06D3gh 0.7200 0.0010 0.000006 2.510000e-07 -0.0270 0.0438 0.4086 0.3863 53922.996094 ... 19 6.700000e-01 23.760000 18.000000 8.960000 4 0 0.0086 -9.707570 11.808599
18 04D3nr 0.9600 0.0010 0.000003 1.980000e-07 0.0073 0.0529 0.2043 0.5112 53185.746094 ... 20 1.130000e-01 17.080000 15.470000 13.600000 4 0 0.0094 -10.417222 21.685776
19 04D4hf 0.9360 0.0010 0.000003 2.060000e-07 0.0485 0.0777 0.7474 0.7232 53236.859375 ... 37 8.040000e-01 12.980000 8.000000 7.620000 4 0 0.0270 -14.111708 44.086575
20 04D4ht 0.2170 0.0010 0.000020 6.150000e-07 0.4388 0.0273 0.7342 0.1556 53257.214844 ... 23 8.940000e-01 99.290001 94.110001 83.639999 4 0 0.0254 -3.143636 45.236729
21 03D3bl 0.3553 0.0010 0.000016 4.190000e-07 0.2067 0.0306 0.2231 0.2374 52786.898438 ... 14 1.590000e-03 70.750000 69.260002 66.919998 4 0 0.0103 -2.566636 27.595621
22 04D1pc 0.7700 0.0010 0.000004 1.170000e-07 0.0971 0.0596 -0.1200 0.3365 53324.890625 ... 34 3.410000e-01 21.940001 17.750000 11.300000 4 0 0.0260 -14.418573 36.943096
23 05D3kp 0.8500 0.0010 0.000005 1.640000e-07 -0.1325 0.0454 1.2563 0.2694 53529.671875 ... 36 9.640000e-01 37.619999 29.530001 16.480000 4 0 0.0106 -14.805446 30.589401
24 05D4ek 0.5360 0.0010 0.000011 3.230000e-07 0.0598 0.0301 0.2434 0.1877 53635.539062 ... 53 3.210000e-01 36.080002 35.369999 17.469999 4 0 0.0276 -14.444232 42.117554
25 06D3cc 0.6830 0.0010 0.000005 3.200000e-07 -0.0145 0.0516 1.0461 0.5486 53760.601562 ... 17 9.660000e-01 31.420000 13.070000 7.900000 4 0 0.0080 -13.661357 24.335800
26 06D3gx 0.7600 0.0010 0.000006 2.530000e-07 -0.1211 0.0713 0.6047 0.6245 53934.625000 ... 10 4.300000e-02 28.070000 22.799999 6.420000 4 0 0.0090 -13.788119 4.939686
27 06D3dl 0.3570 0.0010 0.000027 2.130000e-06 0.0748 0.0390 0.6058 0.4329 53820.535156 ... 24 3.330000e-01 54.540001 35.509998 22.120001 4 0 0.0090 19.832064 46.341022
28 04D2cf 0.3690 0.0010 0.000024 1.190000e-06 -0.0055 0.0367 -0.8226 0.2102 53075.941406 ... 19 8.050000e-01 119.129997 75.480003 63.220001 4 0 0.0185 3.291858 44.109177
29 04D1hx 0.5600 0.0010 0.000008 1.990000e-07 0.1109 0.0335 0.3415 0.2021 53260.042969 ... 50 1.410000e-01 41.549999 36.110001 18.180000 4 0 0.0272 -15.047103 43.824593
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
66 06D2ag 0.3100 0.0010 0.000034 1.090000e-06 0.1040 0.0250 0.6154 0.1415 53756.011719 ... 24 6.690000e-01 160.750000 157.789993 107.820000 4 0 0.0188 -12.632648 34.588253
67 05D2dw 0.4170 0.0010 0.000024 6.960000e-07 -0.0246 0.0258 1.0379 0.1982 53454.300781 ... 22 6.260000e-01 92.000000 77.120003 76.040001 4 0 0.0194 -9.794397 34.580269
68 04D1ff 0.8600 0.0010 0.000005 1.790000e-07 0.0348 0.0526 0.6780 0.2903 53251.128906 ... 48 1.560000e-01 33.570000 12.000000 8.760000 4 0 0.0273 -12.661916 42.640923
69 06D1ab 0.1820 0.0010 0.000060 3.510000e-06 0.1585 0.0505 -2.0499 0.2715 53745.523438 ... 14 4.680000e-03 122.730003 113.970001 88.019997 4 0 0.0256 -16.279758 20.089344
70 03D4dy 0.6100 0.0010 0.000012 3.360000e-07 -0.0895 0.0349 1.2548 0.2323 52904.171875 ... 30 8.250000e-01 44.820000 44.590000 28.570000 4 0 0.0257 -14.778616 36.080273
71 04D3df 0.4700 0.0010 0.000009 2.350000e-07 0.1074 0.0323 -1.8069 0.1678 53119.648438 ... 39 4.300000e-02 76.110001 32.580002 24.120001 4 0 0.0086 -6.910539 42.661633
72 05D3jr 0.3700 0.0010 0.000020 5.230000e-07 0.0582 0.0230 -0.9154 0.1406 53495.000000 ... 40 2.670000e-01 109.220001 89.580002 78.629997 4 0 0.0078 -0.387685 42.635239
73 05D1ix 0.4900 0.0010 0.000016 4.400000e-07 -0.0739 0.0262 0.5297 0.1603 53719.382812 ... 30 1.540000e-01 105.389999 80.459999 56.169998 4 0 0.0272 -14.041814 33.480732
74 03D1aw 0.5820 0.0010 0.000009 2.410000e-07 -0.0328 0.0362 1.1134 0.3270 52902.593750 ... 36 1.980000e-01 48.750000 38.130001 15.590000 4 0 0.0252 -13.916136 44.043034
75 04D2ac 0.3480 0.0010 0.000027 7.600000e-07 0.0670 0.0297 0.4039 0.2006 53032.347656 ... 8 2.640000e-02 137.949997 130.000000 79.070000 4 0 0.0197 -8.054892 38.660728
76 03D3aw 0.4490 0.0010 0.000021 8.500000e-07 -0.1021 0.0409 0.5692 0.2805 52767.394531 ... 13 2.670000e-02 103.199997 52.240002 6.560000 4 0 0.0088 -9.560995 39.273869
77 06D3el 0.5190 0.0010 0.000016 3.930000e-07 -0.1462 0.0270 0.8631 0.1595 53894.457031 ... 37 9.370000e-02 78.580002 76.000000 47.349998 4 0 0.0125 -12.571956 32.168621
78 04D2gc 0.5210 0.0010 0.000011 3.080000e-07 0.0200 0.0353 1.1405 0.2617 53118.164062 ... 14 7.430000e-01 65.949997 39.299999 27.139999 4 0 0.0188 -8.444706 21.760031
79 06D2cd 0.9300 0.0010 0.000003 3.110000e-07 0.0800 0.1100 2.1051 2.1681 53792.046875 ... 27 8.790000e-01 16.629999 6.400000 5.350000 4 0 0.0202 -13.277929 44.680294
80 04D1rx 0.9850 0.0010 0.000003 1.580000e-07 -0.0940 0.0571 0.7276 0.5083 53352.507812 ... 25 3.810000e-01 21.010000 9.990000 9.480000 4 0 0.0248 -15.155598 19.024582
81 05D2nt 0.7570 0.0010 0.000005 1.680000e-07 0.0018 0.0497 1.5736 0.3641 53727.101562 ... 31 5.880000e-01 33.820000 28.959999 18.010000 4 0 0.0179 -13.950198 42.242443
82 03D1fq 0.8000 0.0010 0.000004 1.480000e-07 -0.0487 0.0617 -0.7950 0.3723 52998.867188 ... 14 6.450000e-01 24.940001 15.620000 6.100000 4 0 0.0261 -14.777365 15.261698
83 04D1rh 0.4360 0.0010 0.000022 5.500000e-07 -0.0555 0.0261 1.0389 0.2561 53350.667969 ... 21 5.060000e-01 88.570000 84.209999 56.990002 4 0 0.0254 -14.092958 24.787287
84 04D4ib 0.6990 0.0010 0.000009 2.340000e-07 -0.1128 0.0350 0.8906 0.2339 53267.218750 ... 38 8.580000e-01 37.750000 31.910000 17.900000 4 0 0.0274 -8.139248 37.698837
85 03D1bm 0.5750 0.0010 0.000004 1.590000e-07 0.3542 0.0545 0.5308 0.3486 52917.664062 ... 37 9.480000e-03 23.600000 19.490000 6.660000 4 0 0.0283 -10.897338 34.670616
86 05D3gp 0.5800 0.0010 0.000009 4.310000e-07 -0.0854 0.0458 -0.5630 0.4158 53454.902344 ... 41 3.990000e-01 27.730000 16.280001 9.490000 4 0 0.0088 -9.091593 43.922157
87 03D1co 0.6790 0.0010 0.000005 2.250000e-07 -0.0580 0.0467 0.7554 0.4174 52954.421875 ... 43 5.200000e-01 23.100000 20.370001 7.700000 4 0 0.0299 -14.877913 42.834084
88 04D2fp 0.4150 0.0010 0.000022 5.660000e-07 -0.0481 0.0270 0.3358 0.1454 53107.417969 ... 17 3.000000e-01 68.129997 65.760002 37.189999 4 0 0.0197 -9.926096 30.986008
89 04D4fx 0.6290 0.0010 0.000009 2.690000e-07 -0.0072 0.0350 0.9737 0.2357 53242.492188 ... 43 2.230000e-01 51.810001 41.660000 16.059999 4 0 0.0280 -11.013680 44.676163
90 05D4be 0.5370 0.0010 0.000016 4.120000e-07 -0.1632 0.0274 1.0474 0.1652 53551.507812 ... 51 2.680000e-03 59.610001 55.709999 52.520000 4 0 0.0282 -14.259274 42.890919
91 06D2ga 0.8400 0.0010 0.000004 3.310000e-07 -0.0256 0.0763 1.6814 1.0836 53869.210938 ... 13 5.840000e-01 19.620001 12.970000 7.140000 4 0 0.0198 -11.374167 9.267393
92 05D3mn 0.7600 0.0010 0.000006 1.430000e-07 -0.0260 0.0485 0.1184 0.2980 53559.343750 ... 18 3.440000e-01 58.520000 35.290001 15.490000 4 0 0.0089 -14.225318 15.293503
93 05D2ct 0.7340 0.0010 0.000004 2.200000e-07 0.0969 0.0566 0.3254 0.4992 53425.179688 ... 31 1.340000e-01 19.770000 14.610000 7.420000 4 0 0.0177 -9.653322 40.467876
94 05D2by 0.8910 0.0010 0.000003 1.610000e-07 -0.0148 0.0584 1.5266 0.5413 53413.132812 ... 31 7.830000e-01 26.080000 14.460000 11.210000 4 0 0.0177 -14.585594 43.479332
95 04D1sa 0.5850 0.0010 0.000009 2.780000e-07 -0.0834 0.0337 -0.5237 0.3037 53360.195312 ... 23 2.190000e-01 39.709999 37.189999 23.959999 4 0 0.0252 -11.207556 18.950665

96 rows × 27 columns