In [1]:
import psycopg2
from psycopg2.extensions import register_adapter, AsIs
In [2]:
def insertRow(row,dbname="mimic") :
conn = psycopg2.connect("dbname="+dbname)
cur = conn.cursor()
insert_statement = 'INSERT into heartbeatstemporal (%s) values %s'
columns = row.keys()
values = [row[column] for column in columns]
cur.execute(insert_statement, (AsIs(','.join(columns)), tuple(values)))
conn.commit()
conn.close()
In [3]:
def selectrow(record,dbname="mimic") :
conn = psycopg2.connect("dbname="+dbname)
cur = conn.cursor()
select_stament = ("SELECT a.record, a.sample as s_from, b.Sample - 1 as s_to "
" FROM R a JOIN R b on a.id = b.id -1 and a.record = b.record"
" AND a.record='"+record+"'")
cur.execute(select_stament)
for row in cur :
register = {'record':row[0],'s_from':row[1],'s_to':row[2]}
insertRow(register,dbname="mimic")
In [ ]:
def distinctRecord(dbname="mimic"):
conn = psycopg2.connect("dbname="+dbname)
cur = conn.cursor()
select_stament = "SELECT DISTINCT r.record FROM r WHERE r.record NOT IN (SELECT distinct hb.record FROM heartbeatstemporal hb)"
cur.execute(select_stament)
for record in cur :
print(record[0])
selectrow(record[0])
In [ ]:
distinctRecord()
mimic2wdb/matched/s15883/s15883-3372-09-13-18-22
mimic2wdb/matched/s03768/s03768-2692-06-04-14-43
mimic2wdb/matched/s16122/s16122-3406-05-01-18-32
mimic2wdb/matched/s10611/s10611-3033-05-27-10-49
mimic2wdb/matched/s02981/s02981-3153-10-16-15-40
mimic2wdb/matched/s15382/s15382-2896-08-25-11-43
mimic2wdb/matched/s20922/s20922-3173-01-04-15-06
mimic2wdb/matched/s04656/s04656-3022-07-26-15-31
mimic2wdb/matched/s05237/s05237-2926-10-24-11-50
mimic2wdb/matched/s03340/s03340-2599-03-20-22-56
mimic2wdb/matched/s12739/s12739-3004-09-13-14-31
mimic2wdb/matched/s18413/s18413-3047-06-23-22-31
mimic2wdb/matched/s14346/s14346-2843-09-29-13-40
mimic2wdb/matched/s14584/s14584-2721-07-25-04-26
mimic2wdb/matched/s14298/s14298-3134-10-28-21-18
mimic2wdb/matched/s09593/s09593-2939-07-23-18-20
mimic2wdb/matched/s16129/s16129-3399-09-28-21-42
mimic2wdb/matched/s04566/s04566-2998-05-08-19-21
mimic2wdb/matched/s04369/s04369-2538-08-28-13-15
mimic2wdb/matched/s04401/s04401-3016-12-03-19-13
mimic2wdb/matched/s18688/s18688-3411-08-13-21-20
mimic2wdb/matched/s15052/s15052-2773-09-13-11-56
mimic2wdb/matched/s09555/s09555-3262-03-09-13-38
mimic2wdb/matched/s11291/s11291-3330-05-29-12-51
mimic2wdb/matched/s23130/s23130-3288-08-30-21-50
mimic2wdb/matched/s17774/s17774-3348-04-25-13-13
mimic2wdb/matched/s19765/s19765-2891-12-05-18-05
mimic2wdb/matched/s18685/s18685-3353-12-29-19-01
mimic2wdb/matched/s19999/s19999-2620-11-10-12-40
mimic2wdb/matched/s04338/s04338-3450-10-08-04-34
mimic2wdb/matched/s15185/s15185-3404-07-17-23-24
mimic2wdb/matched/s17483/s17483-2623-05-10-05-31
mimic2wdb/matched/s18621/s18621-3101-09-05-23-32
mimic2wdb/matched/s19330/s19330-3012-03-03-12-17
mimic2wdb/matched/s21050/s21050-3273-03-23-02-28
mimic2wdb/matched/s05114/s05114-2514-11-13-13-17
mimic2wdb/matched/s24124/s24124-3101-01-25-14-16
mimic2wdb/matched/s11431/s11431-3470-12-12-18-51
mimic2wdb/matched/s20474/s20474-2920-06-07-18-19
mimic2wdb/matched/s19538/s19538-3094-11-29-12-36
mimic2wdb/matched/s21072/s21072-2612-04-16-14-21
mimic2wdb/matched/s17589/s17589-2692-01-08-02-38
mimic2wdb/matched/s17589/s17589-2692-01-21-14-04
mimic2wdb/matched/s04362/s04362-2956-10-26-16-07
mimic2wdb/matched/s23890/s23890-2832-10-27-19-04
mimic2wdb/matched/s17582/s17582-2588-03-01-18-23
mimic2wdb/matched/s04742/s04742-2934-11-15-15-32
mimic2wdb/matched/s15426/s15426-3477-05-28-09-30
mimic2wdb/matched/s14836/s14836-3180-02-04-15-32
mimic2wdb/matched/s20860/s20860-3496-03-03-07-46
mimic2wdb/matched/s03744/s03744-2968-03-16-20-14
mimic2wdb/matched/s09555/s09555-3262-03-06-02-46
mimic2wdb/matched/s24152/s24152-3202-06-14-09-32
mimic2wdb/matched/s15779/s15779-3259-07-25-04-52
mimic2wdb/matched/s19608/s19608-3453-01-24-04-57
mimic2wdb/matched/s05496/s05496-2574-10-03-15-18
mimic2wdb/matched/s11187/s11187-2768-11-11-16-37
mimic2wdb/matched/s10842/s10842-3428-05-08-02-26
mimic2wdb/matched/s03441/s03441-3317-07-19-14-32
mimic2wdb/matched/s14266/s14266-2770-01-13-15-29
mimic2wdb/matched/s15567/s15567-2946-08-02-14-26
mimic2wdb/matched/s11604/s11604-2882-06-28-04-14
mimic2wdb/matched/s04264/s04264-3422-12-28-18-12
mimic2wdb/matched/s18546/s18546-2810-10-07-23-50
mimic2wdb/matched/s09575/s09575-3263-07-04-15-08
mimic2wdb/matched/s14899/s14899-3270-10-08-18-48
mimic2wdb/matched/s20238/s20238-3372-09-17-17-46
mimic2wdb/matched/s05417/s05417-3183-09-16-07-45
mimic2wdb/matched/s18688/s18688-3411-08-17-14-00
mimic2wdb/matched/s11341/s11341-2575-05-26-06-41
mimic2wdb/matched/s15595/s15595-3114-03-30-20-22
mimic2wdb/matched/s10924/s10924-2742-07-17-19-19
mimic2wdb/matched/s03695/s03695-3200-09-25-15-38
mimic2wdb/matched/s11161/s11161-2857-04-05-18-22
mimic2wdb/matched/s17488/s17488-3148-12-16-17-23
mimic2wdb/matched/s20612/s20612-3277-07-21-17-12
mimic2wdb/matched/s19055/s19055-3331-04-02-13-33
mimic2wdb/matched/s11684/s11684-3417-09-10-16-01
mimic2wdb/matched/s20658/s20658-2509-07-05-12-19
mimic2wdb/matched/s02981/s02981-3153-10-15-06-55
mimic2wdb/matched/s09615/s09615-2528-10-08-12-28
mimic2wdb/matched/s17735/s17735-3213-09-30-22-27
mimic2wdb/matched/s02827/s02827-3500-09-29-19-37
mimic2wdb/matched/s10653/s10653-3066-03-25-01-23
mimic2wdb/matched/s18681/s18681-2622-12-09-16-21
mimic2wdb/matched/s18035/s18035-3325-05-04-13-36
mimic2wdb/matched/s20658/s20658-2509-07-10-19-48
mimic2wdb/matched/s12878/s12878-3033-11-19-14-56
mimic2wdb/matched/s16117/s16117-3404-06-01-16-34
mimic2wdb/matched/s20482/s20482-2940-04-07-21-36
mimic2wdb/matched/s20742/s20742-3079-06-20-09-25
mimic2wdb/matched/s11609/s11609-3106-06-09-17-08
mimic2wdb/matched/s10689/s10689-3125-08-05-16-43
mimic2wdb/matched/s14291/s14291-2833-12-17-06-10
mimic2wdb/matched/s23363/s23363-2676-12-12-11-07
mimic2wdb/matched/s18300/s18300-2818-10-09-14-18
mimic2wdb/matched/s13136/s13136-2568-10-25-14-55
mimic2wdb/matched/s11744/s11744-2720-11-15-20-55
mimic2wdb/matched/s20471/s20471-3007-10-01-10-02
mimic2wdb/matched/s14524/s14524-3192-08-20-13-16
mimic2wdb/matched/s03586/s03586-2673-02-21-00-49
mimic2wdb/matched/s14897/s14897-3126-02-22-16-20
mimic2wdb/matched/s11467/s11467-3178-09-02-20-36
mimic2wdb/matched/s18998/s18998-3186-09-19-13-21
mimic2wdb/matched/s04401/s04401-3016-12-06-11-47
mimic2wdb/matched/s17697/s17697-2939-09-07-23-23
mimic2wdb/matched/s20860/s20860-3496-02-28-14-14
mimic2wdb/matched/s23893/s23893-3156-11-12-17-20
mimic2wdb/matched/s04641/s04641-3112-08-01-14-02
mimic2wdb/matched/s02827/s02827-3500-09-22-00-02
mimic2wdb/matched/s18818/s18818-3106-11-15-12-13
mimic2wdb/matched/s10782/s10782-3294-11-06-03-53
mimic2wdb/matched/s24227/s24227-3434-11-06-17-58
mimic2wdb/matched/s20846/s20846-2570-04-23-10-07
mimic2wdb/matched/s20246/s20246-3207-03-19-13-19
mimic2wdb/matched/s04894/s04894-3299-07-29-01-06
mimic2wdb/matched/s05175/s05175-3421-03-26-23-49
mimic2wdb/matched/s19442/s19442-3255-08-09-18-36
mimic2wdb/matched/s19087/s19087-2560-06-15-07-53
mimic2wdb/matched/s02906/s02906-3263-01-21-14-17
mimic2wdb/matched/s11464/s11464-2922-06-27-21-53
mimic2wdb/matched/s04481/s04481-2991-10-25-14-08
mimic2wdb/matched/s15254/s15254-3179-11-27-07-41
mimic2wdb/matched/s18942/s18942-3163-12-27-15-59
mimic2wdb/matched/s01995/s01995-3123-12-10-15-38
mimic2wdb/matched/s04805/s04805-2808-01-08-12-32
mimic2wdb/matched/s05332/s05332-3028-05-17-12-58
mimic2wdb/matched/s14947/s14947-3433-11-04-17-06
mimic2wdb/matched/s05037/s05037-3423-03-22-16-56
mimic2wdb/matched/s10487/s10487-3307-09-07-12-54
mimic2wdb/matched/s05126/s05126-2833-06-04-18-11
mimic2wdb/matched/s15797/s15797-3157-09-30-08-19
mimic2wdb/matched/s20354/s20354-2526-08-29-18-00
mimic2wdb/matched/s20766/s20766-2790-04-19-20-53
mimic2wdb/matched/s05609/s05609-2827-12-10-19-26
mimic2wdb/matched/s09363/s09363-2662-11-25-00-27
mimic2wdb/matched/s02787/s02787-3093-06-10-05-42
mimic2wdb/matched/s10241/s10241-3150-11-15-13-27
mimic2wdb/matched/s04778/s04778-2757-02-28-13-59
mimic2wdb/matched/s10638/s10638-2818-03-29-23-37
mimic2wdb/matched/s11688/s11688-3381-10-31-16-45
mimic2wdb/matched/s03386/s03386-2577-08-19-18-08
mimic2wdb/matched/s24063/s24063-3016-12-14-20-47
mimic2wdb/matched/s12968/s12968-3423-03-17-09-59
mimic2wdb/matched/s23363/s23363-2676-12-12-09-28
mimic2wdb/matched/s16139/s16139-3046-10-26-15-48
mimic2wdb/matched/s09330/s09330-3170-10-07-18-50
mimic2wdb/matched/s11191/s11191-3196-03-06-21-04
mimic2wdb/matched/s02834/s02834-3221-07-11-12-23
mimic2wdb/matched/s11638/s11638-3417-11-19-16-25
mimic2wdb/matched/s14947/s14947-3433-11-06-12-07
mimic2wdb/matched/s12987/s12987-2600-04-29-23-48
mimic2wdb/matched/s18413/s18413-3047-06-23-13-18
mimic2wdb/matched/s19246/s19246-2670-10-17-13-55
mimic2wdb/matched/s03466/s03466-3040-10-24-03-31
mimic2wdb/matched/s20856/s20856-2916-09-09-03-55
mimic2wdb/matched/s04324/s04324-3333-09-08-09-58
mimic2wdb/matched/s14240/s14240-3141-10-11-20-57
mimic2wdb/matched/s03214/s03214-3353-08-23-19-27
mimic2wdb/matched/s05198/s05198-2647-08-14-10-57
mimic2wdb/matched/s15646/s15646-3164-11-15-22-30
mimic2wdb/matched/s03914/s03914-2526-10-20-04-36
mimic2wdb/matched/s20354/s20354-2526-08-30-17-26
mimic2wdb/matched/s15144/s15144-3083-02-08-12-33
mimic2wdb/matched/s02921/s02921-2752-06-05-22-29
mimic2wdb/matched/s05332/s05332-3028-05-17-06-34
mimic2wdb/matched/s17617/s17617-2980-09-29-21-24
mimic2wdb/matched/s17666/s17666-3190-12-06-11-07
mimic2wdb/matched/s03780/s03780-2922-01-12-13-30
mimic2wdb/matched/s20354/s20354-2526-08-25-00-53
mimic2wdb/matched/s19965/s19965-2965-04-25-18-22
mimic2wdb/matched/s14938/s14938-3182-08-18-18-51
mimic2wdb/matched/s15727/s15727-2524-05-01-01-33
mimic2wdb/matched/s15733/s15733-2809-09-03-14-44
mimic2wdb/matched/s03593/s03593-3142-11-19-20-58
mimic2wdb/matched/s18982/s18982-3011-11-19-14-08
mimic2wdb/matched/s19372/s19372-3354-08-19-16-08
mimic2wdb/matched/s23448/s23448-2963-05-08-16-01
mimic2wdb/matched/s04870/s04870-2587-11-19-14-37
mimic2wdb/matched/s18786/s18786-3059-01-27-14-02
mimic2wdb/matched/s10275/s10275-2667-01-09-10-26
mimic2wdb/matched/s14322/s14322-2909-12-07-16-02
mimic2wdb/matched/s11710/s11710-3289-06-29-19-26
mimic2wdb/matched/s20564/s20564-2981-11-27-14-36
mimic2wdb/matched/s03506/s03506-3429-03-19-16-01
mimic2wdb/matched/s16032/s16032-3339-07-31-16-59
mimic2wdb/matched/s14919/s14919-2805-04-03-01-50
mimic2wdb/matched/s03386/s03386-2577-08-07-20-40
mimic2wdb/matched/s14836/s14836-3180-02-07-13-57
mimic2wdb/matched/s11727/s11727-2931-10-16-17-09
mimic2wdb/matched/s18239/s18239-2775-11-18-11-35
mimic2wdb/matched/s11318/s11318-2952-09-15-15-57
mimic2wdb/matched/s18739/s18739-2946-09-06-05-04
mimic2wdb/matched/s19099/s19099-3100-12-27-13-00
mimic2wdb/matched/s04068/s04068-2856-10-23-23-32
mimic2wdb/matched/s17696/s17696-3370-11-06-12-07
mimic2wdb/matched/s19430/s19430-3165-10-06-14-40
mimic2wdb/matched/s15247/s15247-2790-11-16-12-59
mimic2wdb/matched/s04324/s04324-3333-09-04-15-16
mimic2wdb/matched/s11242/s11242-2813-10-08-07-22
mimic2wdb/matched/s03995/s03995-3324-03-23-08-49
mimic2wdb/matched/s04806/s04806-2846-07-20-20-06
mimic2wdb/matched/s11744/s11744-2720-11-13-23-41
mimic2wdb/matched/s14204/s14204-2976-10-23-17-00
mimic2wdb/matched/s24228/s24228-2965-03-17-17-00
mimic2wdb/matched/s18166/s18166-3435-06-04-15-54
mimic2wdb/matched/s19102/s19102-3411-09-18-12-36
mimic2wdb/matched/s15749/s15749-2543-08-13-22-56
mimic2wdb/matched/s04771/s04771-3313-04-08-11-22
mimic2wdb/matched/s09354/s09354-2853-09-24-12-00
mimic2wdb/matched/s05321/s05321-2607-05-19-08-38
mimic2wdb/matched/s17472/s17472-3185-03-04-21-42
mimic2wdb/matched/s20190/s20190-2681-10-24-03-34
mimic2wdb/matched/s11342/s11342-2777-09-30-12-41
mimic2wdb/matched/s18169/s18169-3485-08-29-20-27
mimic2wdb/matched/s19445/s19445-2980-01-08-22-27
mimic2wdb/matched/s19411/s19411-3342-06-27-13-19
mimic2wdb/matched/s20345/s20345-2680-06-15-20-38
mimic2wdb/matched/s16122/s16122-3406-05-01-14-21
mimic2wdb/matched/s15964/s15964-3477-07-19-21-10
mimic2wdb/matched/s10552/s10552-3035-09-30-18-48
mimic2wdb/matched/s20190/s20190-2680-11-03-22-55
mimic2wdb/matched/s19538/s19538-3094-12-06-03-47
mimic2wdb/matched/s15271/s15271-3475-02-25-12-31
mimic2wdb/matched/s11464/s11464-2922-06-26-17-19
mimic2wdb/matched/s04018/s04018-3005-08-10-16-58
mimic2wdb/matched/s03863/s03863-2651-08-22-14-11
mimic2wdb/matched/s05607/s05607-3199-07-19-01-18
mimic2wdb/matched/s03513/s03513-3446-06-08-19-10
mimic2wdb/matched/s18676/s18676-3351-06-28-14-32
mimic2wdb/matched/s04599/s04599-2772-10-10-15-55
mimic2wdb/matched/s19578/s19578-3447-11-11-13-47
mimic2wdb/matched/s15583/s15583-3400-07-15-20-31
mimic2wdb/matched/s16139/s16139-3046-10-22-18-17
mimic2wdb/matched/s20479/s20479-2649-10-13-17-20
mimic2wdb/matched/s09286/s09286-2939-04-03-17-54
mimic2wdb/matched/s17589/s17589-2692-01-19-19-11
mimic2wdb/matched/s20929/s20929-2900-02-20-10-26
mimic2wdb/matched/s14205/s14205-2832-11-20-19-24
mimic2wdb/matched/s14542/s14542-3406-06-20-12-35
mimic2wdb/matched/s23339/s23339-3081-07-23-19-23
mimic2wdb/matched/s02996/s02996-3138-05-07-23-12
mimic2wdb/matched/s18681/s18681-2622-05-10-14-50
mimic2wdb/matched/s23318/s23318-3055-10-17-20-25
mimic2wdb/matched/s14622/s14622-2764-10-23-22-16
mimic2wdb/matched/s09593/s09593-2939-08-07-16-42
mimic2wdb/matched/s17722/s17722-2765-03-08-13-09
mimic2wdb/matched/s04142/s04142-3137-10-04-09-22
mimic2wdb/matched/s04474/s04474-3138-02-12-22-06
mimic2wdb/matched/s20372/s20372-2834-10-21-21-10
mimic2wdb/matched/s03133/s03133-3280-05-18-00-10
mimic2wdb/matched/s10738/s10738-2926-02-28-16-03
mimic2wdb/matched/s10689/s10689-3125-08-04-15-28
mimic2wdb/matched/s18166/s18166-3435-06-04-06-38
mimic2wdb/matched/s20407/s20407-3501-02-01-15-12
mimic2wdb/matched/s19498/s19498-2552-02-23-02-20
mimic2wdb/matched/s10652/s10652-2544-09-04-02-52
mimic2wdb/matched/s15654/s15654-2691-12-10-17-43
mimic2wdb/matched/s20643/s20643-3369-05-18-16-04
mimic2wdb/matched/s03748/s03748-3098-07-20-04-10
mimic2wdb/matched/s10766/s10766-3079-04-29-12-39
mimic2wdb/matched/s20129/s20129-2937-08-28-16-50
mimic2wdb/matched/s10748/s10748-3430-11-02-15-59
mimic2wdb/matched/s04481/s04481-2991-10-11-21-42
mimic2wdb/matched/s10769/s10769-3207-03-23-10-12
mimic2wdb/matched/s15964/s15964-3477-07-18-14-29
mimic2wdb/matched/s13191/s13191-2967-08-09-00-25
mimic2wdb/matched/s19208/s19208-3013-07-30-21-25
mimic2wdb/matched/s23180/s23180-2601-05-19-17-27
mimic2wdb/matched/s15631/s15631-2977-12-18-14-14
mimic2wdb/matched/s18733/s18733-2618-03-27-12-08
mimic2wdb/matched/s18982/s18982-3013-04-10-10-42
mimic2wdb/matched/s19931/s19931-3028-07-31-15-22
mimic2wdb/matched/s04685/s04685-2812-01-27-20-04
mimic2wdb/matched/s05619/s05619-2785-09-20-22-15
mimic2wdb/matched/s15640/s15640-2965-05-11-03-35
mimic2wdb/matched/s18975/s18975-2547-03-25-00-55
mimic2wdb/matched/s20856/s20856-2916-09-08-19-03
mimic2wdb/matched/s14539/s14539-3250-11-08-12-17
mimic2wdb/matched/s19604/s19604-3208-12-22-00-30
mimic2wdb/matched/s17483/s17483-2623-05-15-22-58
Content source: davidgutierrez/HeartRatePatterns
Similar notebooks: