import pandas as pd
pd.options.display.float_format = '{:.2f}'.format
pd.set_option('display.max_columns', 500)
h = pd.read_csv('./gravityspy/H1_O3a.csv')
l = pd.read_csv('./gravityspy/L1_O3a.csv')
h.iloc[(h['event_time']-1242442967).abs().argsort(),:]
event_time | ifo | peak_time | peak_time_ns | start_time | start_time_ns | duration | peak_frequency | central_freq | bandwidth | channel | amplitude | snr | q_value | gravityspy_id | 1400Ripples | 1080Lines | Air_Compressor | Blip | Chirp | Extremely_Loud | Helix | Koi_Fish | Light_Modulation | Low_Frequency_Burst | Low_Frequency_Lines | No_Glitch | None_of_the_Above | Paired_Doves | Power_Line | Repeating_Blips | Scattered_Light | Scratchy | Tomte | Violin_Mode | Wandering_Line | Whistle | ml_label | ml_confidence | url1 | url2 | url3 | url4 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
49397 | 1242442819.90 | H1 | 1242442819 | 901854991 | 1242442819 | 250000000 | 1.50 | 217.74 | 672.01 | 1306.19 | GDS-CALIB_STRAIN | 0.00 | 156.46 | 5.66 | edn3fSnQCD | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.91 | 0.00 | 0.00 | 0.00 | 0.00 | 0.05 | 0.00 | 0.00 | 0.02 | 0.00 | 0.00 | 0.01 | 0.00 | 0.00 | 0.00 | Koi_Fish | 1.00 | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... |
16893 | 1242442786.17 | H1 | 1242442786 | 171875000 | 1242442786 | 0 | 0.50 | 11.12 | 11.18 | 2.37 | GDS-CALIB_STRAIN | 0.00 | 9.17 | 11.31 | t3M5OUu8EN | 0.01 | 0.01 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.32 | 0.06 | 0.55 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.01 | 0.00 | 0.01 | 0.00 | 0.01 | No_Glitch | 0.93 | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... |
49372 | 1242442785.86 | H1 | 1242442785 | 859375000 | 1242442785 | 625000000 | 0.38 | 11.12 | 11.18 | 2.37 | GDS-CALIB_STRAIN | 0.00 | 10.12 | 45.25 | 8VXlQq0Asa | 0.05 | 0.01 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.13 | 0.02 | 0.63 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.13 | 0.00 | 0.02 | No_Glitch | 0.67 | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... |
49339 | 1242443404.12 | H1 | 1242443404 | 125000000 | 1242443403 | 500000000 | 1.75 | 26.09 | 2382.92 | 4716.39 | GDS-CALIB_STRAIN | 0.00 | 8.17 | 45.25 | wzWznkXtHq | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.04 | 0.94 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.02 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | Low_Frequency_Lines | 0.88 | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... |
16885 | 1242443450.18 | H1 | 1242443450 | 179198980 | 1242443450 | 156250000 | 0.09 | 217.74 | 325.08 | 482.75 | GDS-CALIB_STRAIN | 0.00 | 8.65 | 5.66 | qvq95iJKOl | 0.00 | 0.00 | 0.00 | 0.71 | 0.00 | 0.00 | 0.01 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.24 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.02 | Blip | 1.00 | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... |
... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
6463 | 1253976363.25 | H1 | 1253976363 | 246093034 | 1253976359 | 500000000 | 8.00 | 39.79 | 3980.24 | 7940.48 | GDS-CALIB_STRAIN | 0.00 | 5919.36 | 11.31 | fq2CvGHZTq | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.63 | 0.00 | 0.15 | 0.04 | 0.02 | 0.00 | 0.00 | 0.10 | 0.00 | 0.00 | 0.01 | 0.01 | 0.00 | 0.00 | 0.02 | 0.00 | 0.01 | Extremely_Loud | 1.00 | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... |
6464 | 1253976363.25 | H1 | 1253976363 | 246093034 | 1253976359 | 500000000 | 8.00 | 39.79 | 3980.24 | 7940.48 | GDS-CALIB_STRAIN | 0.00 | 5919.36 | 11.31 | CiwUNbv1fx | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.63 | 0.00 | 0.15 | 0.04 | 0.02 | 0.00 | 0.00 | 0.10 | 0.00 | 0.00 | 0.01 | 0.01 | 0.00 | 0.00 | 0.02 | 0.00 | 0.01 | Extremely_Loud | 1.00 | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... |
6465 | 1253976363.25 | H1 | 1253976363 | 246093034 | 1253976359 | 500000000 | 8.00 | 39.79 | 3980.24 | 7940.48 | GDS-CALIB_STRAIN | 0.00 | 5919.36 | 11.31 | LOfgpClqDE | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.63 | 0.00 | 0.15 | 0.04 | 0.02 | 0.00 | 0.00 | 0.10 | 0.00 | 0.00 | 0.01 | 0.01 | 0.00 | 0.00 | 0.02 | 0.00 | 0.01 | Extremely_Loud | 1.00 | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... |
6467 | 1253976363.25 | H1 | 1253976363 | 246093034 | 1253976359 | 500000000 | 8.00 | 39.79 | 3980.24 | 7940.48 | GDS-CALIB_STRAIN | 0.00 | 5919.36 | 11.31 | 8ll8shAWxx | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.63 | 0.00 | 0.15 | 0.04 | 0.02 | 0.00 | 0.00 | 0.10 | 0.00 | 0.00 | 0.01 | 0.01 | 0.00 | 0.00 | 0.02 | 0.00 | 0.01 | Extremely_Loud | 1.00 | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... |
80762 | 1253976363.25 | H1 | 1253976363 | 246093034 | 1253976359 | 500000000 | 8.00 | 39.79 | 3980.24 | 7940.48 | GDS-CALIB_STRAIN | 0.00 | 5919.36 | 11.31 | Jxu2wbOnYW | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.63 | 0.00 | 0.15 | 0.04 | 0.02 | 0.00 | 0.00 | 0.10 | 0.00 | 0.00 | 0.01 | 0.01 | 0.00 | 0.00 | 0.02 | 0.00 | 0.01 | Extremely_Loud | 1.00 | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... |
80763 rows × 43 columns
l.iloc[(l['event_time']-1242442967).abs().argsort(),:]
event_time | ifo | peak_time | peak_time_ns | start_time | start_time_ns | duration | peak_frequency | central_freq | bandwidth | channel | amplitude | snr | q_value | gravityspy_id | 1400Ripples | 1080Lines | Air_Compressor | Blip | Chirp | Extremely_Loud | Helix | Koi_Fish | Light_Modulation | Low_Frequency_Burst | Low_Frequency_Lines | No_Glitch | None_of_the_Above | Paired_Doves | Power_Line | Repeating_Blips | Scattered_Light | Scratchy | Tomte | Violin_Mode | Wandering_Line | Whistle | ml_label | ml_confidence | url1 | url2 | url3 | url4 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
81012 | 1242442967.44 | L1 | 1242442967 | 441406011 | 1242442967 | 312500000 | 0.43 | 55.50 | 3419.06 | 6766.56 | GDS-CALIB_STRAIN | 0.00 | 11.20 | 5.66 | 51D9bTFSeY | 0.00 | 0.00 | 0.04 | 0.82 | 0.02 | 0.00 | 0.00 | 0.01 | 0.00 | 0.00 | 0.00 | 0.02 | 0.01 | 0.00 | 0.02 | 0.01 | 0.00 | 0.01 | 0.01 | 0.02 | 0.00 | 0.00 | Blip_Low_Frequency | 0.99 | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... |
81013 | 1242443000.20 | L1 | 1242443000 | 202758073 | 1242443000 | 187500000 | 0.04 | 1191.55 | 2267.08 | 3133.07 | GDS-CALIB_STRAIN | 0.00 | 20.43 | 5.66 | E4Vny1aUFg | 0.00 | 0.19 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.06 | 0.00 | 0.73 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.01 | 0.00 | 0.02 | Violin_Mode | 0.86 | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... |
81018 | 1242442504.31 | L1 | 1242442504 | 310547113 | 1242442504 | 250000000 | 0.09 | 49.21 | 63.19 | 80.64 | GDS-CALIB_STRAIN | 0.00 | 10.14 | 5.66 | zEmb4XriHd | 0.00 | 0.01 | 0.00 | 0.24 | 0.00 | 0.00 | 0.02 | 0.00 | 0.00 | 0.01 | 0.00 | 0.13 | 0.05 | 0.08 | 0.00 | 0.03 | 0.00 | 0.01 | 0.34 | 0.07 | 0.00 | 0.00 | Tomte | 1.00 | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... |
81016 | 1242442461.10 | L1 | 1242442461 | 104979991 | 1242442460 | 750000000 | 1.12 | 269.28 | 3982.89 | 7935.19 | GDS-CALIB_STRAIN | 0.00 | 43.28 | 5.66 | kk8yZYrCpt | 0.00 | 0.00 | 0.00 | 0.04 | 0.00 | 0.00 | 0.22 | 0.08 | 0.01 | 0.00 | 0.00 | 0.01 | 0.03 | 0.00 | 0.00 | 0.59 | 0.00 | 0.00 | 0.00 | 0.01 | 0.00 | 0.00 | Koi_Fish | 0.99 | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... |
81017 | 1242443753.92 | L1 | 1242443753 | 921386003 | 1242443753 | 906250000 | 0.03 | 1192.25 | 1900.18 | 2399.28 | GDS-CALIB_STRAIN | 0.00 | 19.59 | 11.31 | lCMJhvcMdY | 0.00 | 0.08 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.01 | 0.00 | 0.87 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.03 | Whistle | 0.78 | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... |
... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
8258 | 1253972986.32 | L1 | 1253972986 | 324218034 | 1253972986 | 0 | 0.50 | 39.79 | 1514.74 | 2991.66 | GDS-CALIB_STRAIN | 0.00 | 18.22 | 5.66 | E8pQZ0S4wu | 0.00 | 0.00 | 0.00 | 0.92 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.02 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.05 | 0.00 | 0.00 | 0.00 | Tomte | 1.00 | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... |
6594 | 1253973014.08 | L1 | 1253973014 | 83983898 | 1253973013 | 500000000 | 1.25 | 49.21 | 3239.72 | 6448.84 | GDS-CALIB_STRAIN | 0.00 | 34.24 | 5.66 | 5EI8LwhUY1 | 0.00 | 0.00 | 0.00 | 0.91 | 0.00 | 0.00 | 0.00 | 0.02 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.05 | 0.00 | 0.00 | 0.00 | Tomte | 1.00 | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... |
7992 | 1253973354.90 | L1 | 1253973354 | 904297113 | 1253973354 | 0 | 2.51 | 49.21 | 543.38 | 1056.17 | GDS-CALIB_STRAIN | 0.00 | 40.21 | 5.66 | huF1ABmNPZ | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.04 | 0.01 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.95 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | Koi_Fish | 0.92 | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... |
6593 | 1253973595.20 | L1 | 1253973595 | 195312023 | 1253973594 | 625000000 | 0.88 | 34.59 | 34.94 | 23.09 | GDS-CALIB_STRAIN | 0.00 | 8.30 | 11.31 | 7GTiJvzkvn | 0.00 | 0.06 | 0.09 | 0.00 | 0.00 | 0.00 | 0.10 | 0.00 | 0.00 | 0.55 | 0.03 | 0.08 | 0.03 | 0.01 | 0.00 | 0.00 | 0.05 | 0.00 | 0.00 | 0.00 | 0.00 | 0.01 | Fast_Scattering | 1.00 | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... |
6604 | 1253973601.74 | L1 | 1253973601 | 742187023 | 1253973601 | 292968034 | 0.71 | 38.93 | 3686.51 | 7315.16 | GDS-CALIB_STRAIN | 0.00 | 8.79 | 11.31 | MUusQXpCjQ | 0.00 | 0.00 | 0.21 | 0.00 | 0.00 | 0.00 | 0.01 | 0.00 | 0.00 | 0.04 | 0.00 | 0.00 | 0.01 | 0.00 | 0.00 | 0.00 | 0.72 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | Fast_Scattering | 1.00 | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... | https://panoptes-uploads.zooniverse.org/produc... |
127500 rows × 43 columns