In [7]:
import os
#查詢指定路徑內的所有資料匣及檔案(以List回傳)
input_path = "../../../GitHub/temp/web_crawler/download/"
files = []
for root, dirs, files in os.walk(input_path):
print("path:", root)
print("dir:", dirs)
print("files:", files)
path: ../../../GitHub/temp/web_crawler/download/
dir: []
files: ['NTUH_T0_DENT_1_20171102_20171102155115.csv', 'NTUH_T0_DENT_1_20171103_20171103090314.csv', 'NTUH_T0_DENT_1_20171103_20171103090813.csv', 'NTUH_T0_DENT_1_20171103_20171103091313.csv', 'NTUH_T0_DENT_1_20171103_20171103091813.csv', 'NTUH_T0_DENT_1_20171103_20171103092313.csv', 'NTUH_T0_DENT_1_20171103_20171103092812.csv', 'NTUH_T0_DENT_1_20171103_20171103093312.csv', 'NTUH_T0_DENT_1_20171103_20171103093812.csv', 'NTUH_T0_DENT_1_20171103_20171103094312.csv', 'NTUH_T0_DENT_1_20171103_20171103094812.csv', 'NTUH_T0_DENT_1_20171103_20171103095313.csv', 'NTUH_T0_DENT_1_20171103_20171103095812.csv', 'NTUH_T0_DENT_1_20171103_20171103100312.csv', 'NTUH_T0_DENT_1_20171103_20171103100812.csv', 'NTUH_T0_DENT_1_20171103_20171103101312.csv', 'NTUH_T0_DENT_1_20171103_20171103101812.csv', 'NTUH_T0_DENT_1_20171103_20171103102312.csv', 'NTUH_T0_DENT_1_20171103_20171103102812.csv', 'NTUH_T0_DENT_1_20171103_20171103103312.csv', 'NTUH_T0_DENT_1_20171103_20171103103812.csv', 'NTUH_T0_DENT_1_20171103_20171103104312.csv', 'NTUH_T0_DENT_1_20171103_20171103104812.csv', 'NTUH_T0_DENT_1_20171103_20171103105312.csv', 'NTUH_T0_DENT_1_20171103_20171103105812.csv', 'NTUH_T0_DENT_1_20171103_20171103110313.csv', 'NTUH_T0_DENT_1_20171103_20171103110812.csv', 'NTUH_T0_DENT_1_20171103_20171103111312.csv', 'NTUH_T0_DENT_1_20171103_20171103111812.csv', 'NTUH_T0_DENT_1_20171103_20171103112312.csv', 'NTUH_T0_DENT_1_20171103_20171103112812.csv', 'NTUH_T0_DENT_1_20171103_20171103113313.csv', 'NTUH_T0_DENT_1_20171103_20171103113812.csv', 'NTUH_T0_DENT_1_20171103_20171103114312.csv', 'NTUH_T0_DENT_1_20171103_20171103114813.csv', 'NTUH_T0_DENT_1_20171103_20171103115312.csv', 'NTUH_T0_DENT_1_20171103_20171103115812.csv', 'NTUH_T0_DENT_1_20171103_20171103120313.csv', 'NTUH_T0_DENT_1_20171103_20171103120813.csv', 'NTUH_T0_DENT_1_20171103_20171103121313.csv', 'NTUH_T0_DENT_1_20171103_20171103121814.csv', 'NTUH_T0_DENT_1_20171103_20171103122314.csv', 'NTUH_T0_DENT_1_20171103_20171103122813.csv', 'NTUH_T0_DENT_1_20171103_20171103123313.csv', 'NTUH_T0_DENT_1_20171103_20171103123814.csv', 'NTUH_T0_DENT_1_20171103_20171103124314.csv', 'NTUH_T0_DENT_1_20171103_20171103124814.csv', 'NTUH_T0_DENT_1_20171103_20171103125313.csv', 'NTUH_T0_DENT_1_20171103_20171103125815.csv', 'NTUH_T0_DENT_1_20171103_20171103130313.csv', 'NTUH_T0_DENT_1_20171103_20171103130813.csv', 'NTUH_T0_DENT_1_20171103_20171103131313.csv', 'NTUH_T0_DENT_1_20171103_20171103131813.csv', 'NTUH_T0_DENT_1_20171103_20171103132313.csv', 'NTUH_T0_DENT_1_20171103_20171103132813.csv', 'NTUH_T0_DENT_1_20171103_20171103133313.csv', 'NTUH_T0_DENT_1_20171103_20171103133815.csv', 'NTUH_T0_DENT_1_20171103_20171103134341.csv', 'NTUH_T0_DENT_1_20171103_20171103134814.csv', 'NTUH_T0_DENT_1_20171103_20171103135313.csv', 'NTUH_T0_DENT_1_20171103_20171103135814.csv', 'NTUH_T0_DENT_2_20171103_20171103154150.csv', 'NTUH_T0_DENT_2_20171103_20171103154408.csv', 'NTUH_T0_DENT_2_20171103_20171103154905.csv', 'NTUH_T0_DENT_2_20171103_20171103155405.csv', 'NTUH_T0_DENT_2_20171103_20171103155905.csv', 'NTUH_T0_DENT_2_20171103_20171103160405.csv', 'NTUH_T0_DENT_2_20171103_20171103160905.csv', 'NTUH_T0_DENT_2_20171103_20171103161405.csv', 'NTUH_T0_DENT_2_20171103_20171103161905.csv', 'NTUH_T0_DENT_2_20171103_20171103162405.csv', 'NTUH_T0_DENT_2_20171103_20171103162905.csv', 'NTUH_T0_DENT_2_20171103_20171103163405.csv', 'NTUH_T0_DENT_2_20171103_20171103163905.csv', 'NTUH_T0_DENT_2_20171103_20171103164405.csv', 'NTUH_T0_DENT_2_20171103_20171103164906.csv', 'NTUH_T0_DENT_2_20171103_20171103165405.csv', 'NTUH_T0_DENT_2_20171103_20171103165905.csv', 'NTUH_T0_DENT_2_20171103_20171103170405.csv', 'NTUH_T0_DENT_2_20171103_20171103170905.csv', 'NTUH_T0_DENT_2_20171103_20171103171405.csv', 'NTUH_T0_DENT_2_20171103_20171103171905.csv', 'NTUH_T0_DENT_2_20171103_20171103172405.csv', 'NTUH_T0_DENT_2_20171103_20171103172905.csv', 'NTUH_T0_DENT_2_20171103_20171103173405.csv', 'NTUH_T0_DENT_2_20171103_20171103173905.csv', 'NTUH_T0_DENT_2_20171103_20171103174405.csv', 'NTUH_T0_DENT_2_20171103_20171103174905.csv', 'NTUH_T0_DENT_2_20171103_20171103175405.csv', 'NTUH_T0_DENT_2_20171103_20171103175905.csv', 'NTUH_T0_DENT_2_20171103_20171103180405.csv', 'NTUH_T0_DENT_2_20171103_20171103180911.csv', 'NTUH_T0_DENT_2_20171103_20171103181417.csv', 'NTUH_T0_DENT_2_20171103_20171103181912.csv', 'NTUH_T0_DENT_2_20171103_20171103182410.csv', 'NTUH_T0_DENT_2_20171103_20171103182911.csv', 'NTUH_T0_DENT_3_20171103_20171103183409.csv', 'NTUH_T0_DENT_3_20171103_20171103183909.csv', 'NTUH_T0_DENT_3_20171103_20171103184410.csv', 'NTUH_T0_DENT_3_20171103_20171103184909.csv', 'NTUH_T0_DENT_3_20171103_20171103185409.csv', 'NTUH_T0_DENT_3_20171103_20171103185910.csv', 'NTUH_T0_DENT_3_20171103_20171103190409.csv', 'NTUH_T0_DENT_3_20171103_20171103190909.csv', 'NTUH_T0_DENT_3_20171103_20171103191409.csv', 'NTUH_T0_DENT_3_20171103_20171103191909.csv', 'NTUH_T0_DENT_3_20171103_20171103192409.csv', 'NTUH_T0_DENT_3_20171103_20171103192909.csv', 'NTUH_T0_DENT_3_20171103_20171103193409.csv', 'NTUH_T0_DENT_3_20171103_20171103193909.csv', 'NTUH_T0_DENT_3_20171103_20171103194409.csv', 'NTUH_T0_DENT_3_20171103_20171103194912.csv', 'NTUH_T0_DENT_3_20171103_20171103195411.csv', 'NTUH_T0_DENT_3_20171103_20171103195909.csv', 'NTUH_T0_DENT_3_20171103_20171103200410.csv', 'NTUH_T0_DENT_3_20171103_20171103200909.csv', 'NTUH_T0_DENT_3_20171103_20171103201409.csv', 'NTUH_T0_DENT_3_20171103_20171103201912.csv', 'NTUH_T0_DENT_3_20171103_20171103202410.csv', 'NTUH_T0_DENT_3_20171103_20171103202909.csv', 'NTUH_T0_DENT_3_20171103_20171103203412.csv', 'NTUH_T0_DENT_3_20171103_20171103203912.csv', 'NTUH_T0_DENT_3_20171103_20171103204410.csv', 'NTUH_T0_DENT_3_20171103_20171103204909.csv', 'NTUH_T0_DENT_3_20171103_20171103205916.csv', 'NTUH_T0_DENT_3_20171103_20171103210425.csv', 'NTUH_T0_DENT_3_20171103_20171103210940.csv', 'NTUH_T0_MED_1_20171102_20171102155116.csv', 'NTUH_T0_MED_1_20171103_20171103090314.csv', 'NTUH_T0_MED_1_20171103_20171103090813.csv', 'NTUH_T0_MED_1_20171103_20171103091313.csv', 'NTUH_T0_MED_1_20171103_20171103091813.csv', 'NTUH_T0_MED_1_20171103_20171103092313.csv', 'NTUH_T0_MED_1_20171103_20171103092813.csv', 'NTUH_T0_MED_1_20171103_20171103093313.csv', 'NTUH_T0_MED_1_20171103_20171103093813.csv', 'NTUH_T0_MED_1_20171103_20171103094313.csv', 'NTUH_T0_MED_1_20171103_20171103094813.csv', 'NTUH_T0_MED_1_20171103_20171103095313.csv', 'NTUH_T0_MED_1_20171103_20171103095813.csv', 'NTUH_T0_MED_1_20171103_20171103100313.csv', 'NTUH_T0_MED_1_20171103_20171103100813.csv', 'NTUH_T0_MED_1_20171103_20171103101313.csv', 'NTUH_T0_MED_1_20171103_20171103101813.csv', 'NTUH_T0_MED_1_20171103_20171103102313.csv', 'NTUH_T0_MED_1_20171103_20171103102813.csv', 'NTUH_T0_MED_1_20171103_20171103103313.csv', 'NTUH_T0_MED_1_20171103_20171103103813.csv', 'NTUH_T0_MED_1_20171103_20171103104313.csv', 'NTUH_T0_MED_1_20171103_20171103104813.csv', 'NTUH_T0_MED_1_20171103_20171103105313.csv', 'NTUH_T0_MED_1_20171103_20171103105813.csv', 'NTUH_T0_MED_1_20171103_20171103110313.csv', 'NTUH_T0_MED_1_20171103_20171103110813.csv', 'NTUH_T0_MED_1_20171103_20171103111313.csv', 'NTUH_T0_MED_1_20171103_20171103111813.csv', 'NTUH_T0_MED_1_20171103_20171103112313.csv', 'NTUH_T0_MED_1_20171103_20171103112813.csv', 'NTUH_T0_MED_1_20171103_20171103113313.csv', 'NTUH_T0_MED_1_20171103_20171103113813.csv', 'NTUH_T0_MED_1_20171103_20171103114313.csv', 'NTUH_T0_MED_1_20171103_20171103114813.csv', 'NTUH_T0_MED_1_20171103_20171103115313.csv', 'NTUH_T0_MED_1_20171103_20171103115813.csv', 'NTUH_T0_MED_1_20171103_20171103120314.csv', 'NTUH_T0_MED_1_20171103_20171103120813.csv', 'NTUH_T0_MED_1_20171103_20171103121314.csv', 'NTUH_T0_MED_1_20171103_20171103121814.csv', 'NTUH_T0_MED_1_20171103_20171103122314.csv', 'NTUH_T0_MED_1_20171103_20171103122814.csv', 'NTUH_T0_MED_1_20171103_20171103123314.csv', 'NTUH_T0_MED_1_20171103_20171103123815.csv', 'NTUH_T0_MED_1_20171103_20171103124315.csv', 'NTUH_T0_MED_1_20171103_20171103124815.csv', 'NTUH_T0_MED_1_20171103_20171103125314.csv', 'NTUH_T0_MED_1_20171103_20171103125814.csv', 'NTUH_T0_MED_1_20171103_20171103130314.csv', 'NTUH_T0_MED_1_20171103_20171103130814.csv', 'NTUH_T0_MED_1_20171103_20171103131314.csv', 'NTUH_T0_MED_1_20171103_20171103131813.csv', 'NTUH_T0_MED_1_20171103_20171103132313.csv', 'NTUH_T0_MED_1_20171103_20171103132813.csv', 'NTUH_T0_MED_1_20171103_20171103133313.csv', 'NTUH_T0_MED_1_20171103_20171103133815.csv', 'NTUH_T0_MED_1_20171103_20171103134316.csv', 'NTUH_T0_MED_1_20171103_20171103134815.csv', 'NTUH_T0_MED_1_20171103_20171103135313.csv', 'NTUH_T0_MED_1_20171103_20171103135814.csv', 'NTUH_T0_MED_2_20171103_20171103154152.csv', 'NTUH_T0_MED_2_20171103_20171103154409.csv', 'NTUH_T0_MED_2_20171103_20171103154905.csv', 'NTUH_T0_MED_2_20171103_20171103155405.csv', 'NTUH_T0_MED_2_20171103_20171103155906.csv', 'NTUH_T0_MED_2_20171103_20171103160406.csv', 'NTUH_T0_MED_2_20171103_20171103160905.csv', 'NTUH_T0_MED_2_20171103_20171103161405.csv', 'NTUH_T0_MED_2_20171103_20171103161905.csv', 'NTUH_T0_MED_2_20171103_20171103162405.csv', 'NTUH_T0_MED_2_20171103_20171103162905.csv', 'NTUH_T0_MED_2_20171103_20171103163406.csv', 'NTUH_T0_MED_2_20171103_20171103163906.csv', 'NTUH_T0_MED_2_20171103_20171103164405.csv', 'NTUH_T0_MED_2_20171103_20171103164906.csv', 'NTUH_T0_MED_2_20171103_20171103165405.csv', 'NTUH_T0_MED_2_20171103_20171103165905.csv', 'NTUH_T0_MED_2_20171103_20171103170405.csv', 'NTUH_T0_MED_2_20171103_20171103170905.csv', 'NTUH_T0_MED_2_20171103_20171103171405.csv', 'NTUH_T0_MED_2_20171103_20171103171905.csv', 'NTUH_T0_MED_2_20171103_20171103172405.csv', 'NTUH_T0_MED_2_20171103_20171103172905.csv', 'NTUH_T0_MED_2_20171103_20171103173406.csv', 'NTUH_T0_MED_2_20171103_20171103173905.csv', 'NTUH_T0_MED_2_20171103_20171103174405.csv', 'NTUH_T0_MED_2_20171103_20171103174905.csv', 'NTUH_T0_MED_2_20171103_20171103175406.csv', 'NTUH_T0_MED_2_20171103_20171103175906.csv', 'NTUH_T0_MED_2_20171103_20171103180406.csv', 'NTUH_T0_MED_2_20171103_20171103180914.csv', 'NTUH_T0_MED_2_20171103_20171103181417.csv', 'NTUH_T0_MED_2_20171103_20171103181912.csv', 'NTUH_T0_MED_2_20171103_20171103182411.csv', 'NTUH_T0_MED_2_20171103_20171103182913.csv', 'NTUH_T0_MED_3_20171103_20171103183409.csv', 'NTUH_T0_MED_3_20171103_20171103183909.csv', 'NTUH_T0_MED_3_20171103_20171103184410.csv', 'NTUH_T0_MED_3_20171103_20171103184909.csv', 'NTUH_T0_MED_3_20171103_20171103185409.csv', 'NTUH_T0_MED_3_20171103_20171103185910.csv', 'NTUH_T0_MED_3_20171103_20171103190409.csv', 'NTUH_T0_MED_3_20171103_20171103190909.csv', 'NTUH_T0_MED_3_20171103_20171103191409.csv', 'NTUH_T0_MED_3_20171103_20171103191909.csv', 'NTUH_T0_MED_3_20171103_20171103192409.csv', 'NTUH_T0_MED_3_20171103_20171103192909.csv', 'NTUH_T0_MED_3_20171103_20171103193409.csv', 'NTUH_T0_MED_3_20171103_20171103193909.csv', 'NTUH_T0_MED_3_20171103_20171103194409.csv', 'NTUH_T0_MED_3_20171103_20171103194912.csv', 'NTUH_T0_MED_3_20171103_20171103195410.csv', 'NTUH_T0_MED_3_20171103_20171103195909.csv', 'NTUH_T0_MED_3_20171103_20171103200410.csv', 'NTUH_T0_MED_3_20171103_20171103200909.csv', 'NTUH_T0_MED_3_20171103_20171103201409.csv', 'NTUH_T0_MED_3_20171103_20171103201913.csv', 'NTUH_T0_MED_3_20171103_20171103202409.csv', 'NTUH_T0_MED_3_20171103_20171103202910.csv', 'NTUH_T0_MED_3_20171103_20171103203412.csv', 'NTUH_T0_MED_3_20171103_20171103203911.csv', 'NTUH_T0_MED_3_20171103_20171103204410.csv', 'NTUH_T0_MED_3_20171103_20171103204909.csv', 'NTUH_T0_MED_3_20171103_20171103205919.csv', 'NTUH_T0_MED_3_20171103_20171103210426.csv', 'NTUH_T0_MED_3_20171103_20171103210943.csv', 'NTUH_T0_PED_1_20171102_20171102155114.csv', 'NTUH_T0_PED_1_20171103_20171103090312.csv', 'NTUH_T0_PED_1_20171103_20171103090811.csv', 'NTUH_T0_PED_1_20171103_20171103091312.csv', 'NTUH_T0_PED_1_20171103_20171103091811.csv', 'NTUH_T0_PED_1_20171103_20171103092311.csv', 'NTUH_T0_PED_1_20171103_20171103092811.csv', 'NTUH_T0_PED_1_20171103_20171103093311.csv', 'NTUH_T0_PED_1_20171103_20171103093811.csv', 'NTUH_T0_PED_1_20171103_20171103094311.csv', 'NTUH_T0_PED_1_20171103_20171103094811.csv', 'NTUH_T0_PED_1_20171103_20171103095311.csv', 'NTUH_T0_PED_1_20171103_20171103095811.csv', 'NTUH_T0_PED_1_20171103_20171103100311.csv', 'NTUH_T0_PED_1_20171103_20171103100811.csv', 'NTUH_T0_PED_1_20171103_20171103101311.csv', 'NTUH_T0_PED_1_20171103_20171103101811.csv', 'NTUH_T0_PED_1_20171103_20171103102311.csv', 'NTUH_T0_PED_1_20171103_20171103102811.csv', 'NTUH_T0_PED_1_20171103_20171103103311.csv', 'NTUH_T0_PED_1_20171103_20171103103811.csv', 'NTUH_T0_PED_1_20171103_20171103104311.csv', 'NTUH_T0_PED_1_20171103_20171103104811.csv', 'NTUH_T0_PED_1_20171103_20171103105311.csv', 'NTUH_T0_PED_1_20171103_20171103105811.csv', 'NTUH_T0_PED_1_20171103_20171103110311.csv', 'NTUH_T0_PED_1_20171103_20171103110811.csv', 'NTUH_T0_PED_1_20171103_20171103111311.csv', 'NTUH_T0_PED_1_20171103_20171103111811.csv', 'NTUH_T0_PED_1_20171103_20171103112311.csv', 'NTUH_T0_PED_1_20171103_20171103112811.csv', 'NTUH_T0_PED_1_20171103_20171103113312.csv', 'NTUH_T0_PED_1_20171103_20171103113811.csv', 'NTUH_T0_PED_1_20171103_20171103114311.csv', 'NTUH_T0_PED_1_20171103_20171103114811.csv', 'NTUH_T0_PED_1_20171103_20171103115311.csv', 'NTUH_T0_PED_1_20171103_20171103115811.csv', 'NTUH_T0_PED_1_20171103_20171103120312.csv', 'NTUH_T0_PED_1_20171103_20171103120812.csv', 'NTUH_T0_PED_1_20171103_20171103121311.csv', 'NTUH_T0_PED_1_20171103_20171103121812.csv', 'NTUH_T0_PED_1_20171103_20171103122312.csv', 'NTUH_T0_PED_1_20171103_20171103122812.csv', 'NTUH_T0_PED_1_20171103_20171103123312.csv', 'NTUH_T0_PED_1_20171103_20171103123812.csv', 'NTUH_T0_PED_1_20171103_20171103124312.csv', 'NTUH_T0_PED_1_20171103_20171103124812.csv', 'NTUH_T0_PED_1_20171103_20171103125312.csv', 'NTUH_T0_PED_1_20171103_20171103125812.csv', 'NTUH_T0_PED_1_20171103_20171103130312.csv', 'NTUH_T0_PED_1_20171103_20171103130811.csv', 'NTUH_T0_PED_1_20171103_20171103131312.csv', 'NTUH_T0_PED_1_20171103_20171103131811.csv', 'NTUH_T0_PED_1_20171103_20171103132311.csv', 'NTUH_T0_PED_1_20171103_20171103132811.csv', 'NTUH_T0_PED_1_20171103_20171103133311.csv', 'NTUH_T0_PED_1_20171103_20171103133812.csv', 'NTUH_T0_PED_1_20171103_20171103134315.csv', 'NTUH_T0_PED_1_20171103_20171103134812.csv', 'NTUH_T0_PED_1_20171103_20171103135311.csv', 'NTUH_T0_PED_1_20171103_20171103135811.csv']
In [14]:
#檔名日期判別方式:
date_flag = "20171103"
"_{}_".format(date_flag) in 'NTUH_T0_DENT_1_20171102_20171103090314.csv'
Out[14]:
False
In [13]:
#read CSV file by date_flag
import pandas as pd
date_flag = "20171103"
df = pd.DataFrame(columns=["clinic_name","clinic_no","dr_name","is_close","light_no_show","light_no_time","remark1","timestamp"])
for fn in files:
if "_{}_".format(date_flag) in fn:
tmp = pd.read_csv(input_path+fn)
df = df.append(tmp, ignore_index=True)
In [15]:
#write daily summary file with date_flag name
import datetime as dt
output_path = "../../../GitHub/temp/web_crawler/daily_summmary/"
if not os.path.exists(output_path):
os.makedirs(output_path)
df.to_csv(output_path+'{}.csv'.format(date_flag), index=False, encoding="utf-8")
In [20]:
temp_data = pd.read_csv("{}{}.csv".format(output_path,date_flag))
temp_data
Out[20]:
clinic_name
clinic_no
dr_name
is_close
light_no_show
light_no_time
remark1
timestamp
0
口腔顎面外科_O2
01 診
楊方瑜
0
NaN
--:--
03;
2017-11-03 09:03:14.610308
1
口腔顎面外科教學門診_O5
02 診
林鴻穎
0
NaN
--:--
05;
2017-11-03 09:03:14.610308
2
口腔顎面外科_O2
03 診
住院醫師
0
NaN
--:--
03;
2017-11-03 09:03:14.610308
3
口腔顎面外科_O2
04 診
住院醫師
0
NaN
--:--
NaN
2017-11-03 09:03:14.610308
4
口腔顎面外科_O1
05 診
郭生興
0
NaN
09:01
05;
2017-11-03 09:03:14.610308
5
口腔顎面外科_O2
07 診
陳信銘
0
NaN
--:--
03;
2017-11-03 09:03:14.610308
6
口腔顎面外科_O2
09 診
彭馨慧
0
NaN
08:07
03;
2017-11-03 09:03:14.610308
7
補綴_O2
12 診
蕭裕源
0
NaN
--:--
03;
2017-11-03 09:03:14.610308
8
醫師約診_O2
14 診
張玉芳
0
1.0
09:00
03;
2017-11-03 09:03:14.610308
9
普通門診_O1
20 診
李明澍
0
NaN
--:--
05;
2017-11-03 09:03:14.610308
10
普通門診_O1
22 診
NaN
0
NaN
08:50
05;
2017-11-03 09:03:14.610308
11
醫師約診_O2
23 診
林思洸
0
NaN
--:--
03;05;
2017-11-03 09:03:14.610308
12
醫師約診_O2
24 診
NaN
0
NaN
--:--
03;
2017-11-03 09:03:14.610308
13
醫師約診_O2
25 診
林思洸
0
NaN
--:--
03;05;
2017-11-03 09:03:14.610308
14
醫師約診_O2
26 診
NaN
0
NaN
--:--
05;
2017-11-03 09:03:14.610308
15
醫師約診_O2
27 診
李明澍
0
NaN
--:--
03;05;
2017-11-03 09:03:14.610308
16
牙周病_O2
28 診
NaN
0
NaN
--:--
03;04;05;
2017-11-03 09:03:14.610308
17
牙體復形_O2
31 診
NaN
0
NaN
--:--
03;
2017-11-03 09:03:14.610308
18
牙髓病治療_O2
36 診
林思洸
0
NaN
--:--
03;
2017-11-03 09:03:14.610308
19
補綴_O2
44 診
李明澍
0
NaN
--:--
05;
2017-11-03 09:03:14.610308
20
補綴_O2
46 診
胡家源
0
NaN
--:--
03;
2017-11-03 09:03:14.610308
21
牙周病_O2
51 診
NaN
0
NaN
--:--
NaN
2017-11-03 09:03:14.610308
22
齒顎矯正自費門診_O1
59 診
陳羿貞
0
NaN
--:--
04;05;
2017-11-03 09:03:14.610308
23
齒列矯正_O2
61 診
陳羿貞
0
NaN
--:--
NaN
2017-11-03 09:03:14.610308
24
特別門診_O2
72 診
江俊斌
0
NaN
--:--
03;
2017-11-03 09:03:14.610308
25
特別門診_O2
73 診
陳信銘
0
NaN
--:--
03;
2017-11-03 09:03:14.610308
26
特別門診_O2
74 診
王若松
0
NaN
--:--
03;
2017-11-03 09:03:14.610308
27
特別門診_O2
75 診
林立德
0
NaN
--:--
03;
2017-11-03 09:03:14.610308
28
特別門診_O2
76 診
陳韻之
0
NaN
--:--
03;
2017-11-03 09:03:14.610308
29
口腔顎面外科_O2
01 診
楊方瑜
0
NaN
--:--
03;
2017-11-03 09:08:13.133764
...
...
...
...
...
...
...
...
...
6255
心臟血管_O1
11 診
NaN
1
NaN
16:51
NaN
2017-11-03 18:29:13.455323
6256
呼吸系_O1
12 診
許嘉林
1
NaN
18:15
NaN
2017-11-03 18:29:13.455323
6257
消化系_O2
13 診
楊培銘
1
NaN
17:16
NaN
2017-11-03 18:29:13.455323
6258
消化系_O1
14 診
陳介章
0
74.0
18:26
NaN
2017-11-03 18:29:13.455323
6259
感染症_O1
15 診
鄭琬豒
1
NaN
17:45
NaN
2017-11-03 18:29:13.455323
6260
血液病_O1
16 診
蔡承宏
0
8.0
18:26
NaN
2017-11-03 18:29:13.455323
6261
風濕病/關節炎_O1
17 診
郭佑民
0
86.0
18:25
NaN
2017-11-03 18:29:13.455323
6262
呼吸系_O1
18 診
陳啟信
1
NaN
18:09
03;
2017-11-03 18:29:13.455323
6263
醫師約診_O2
19 診
李啟明
0
NaN
14:41
NaN
2017-11-03 18:29:13.455323
6264
內分泌_O2
20 診
邱偉益
0
57.0
18:20
03;
2017-11-03 18:29:13.455323
6265
心臟血管教學診_O5
22 診
潘恆宇
1
NaN
16:49
NaN
2017-11-03 18:29:13.455323
6266
消化系_O2
23 診
翁昭旼
0
21.0
17:56
03;
2017-11-03 18:29:13.455323
6267
血液病_O1
24 診
陳尹愷
0
37.0
18:16
NaN
2017-11-03 18:29:13.455323
6268
呼吸系_O1
25 診
楊景堯
1
NaN
18:04
NaN
2017-11-03 18:29:13.455323
6269
感染症_O2
26 診
盛望徽
0
NaN
17:25
05;
2017-11-03 18:29:13.455323
6270
消化系_O1
27 診
洪俊銘
1
NaN
17:56
NaN
2017-11-03 18:29:13.455323
6271
腎臟科_O1
28 診
姜文智
1
NaN
16:57
NaN
2017-11-03 18:29:13.455323
6272
消化系_O1
29 診
鄭祖耀
0
49.0
18:09
NaN
2017-11-03 18:29:13.455323
6273
心臟血管_O1
30 診
陳文鍾
1
NaN
17:09
NaN
2017-11-03 18:29:13.455323
6274
內分泌_O2
31 診
張天鈞
1
NaN
17:21
03;
2017-11-03 18:29:13.455323
6275
心臟血管_O1
32 診
劉言彬
0
81.0
18:29
NaN
2017-11-03 18:29:13.455323
6276
呼吸系_O1
33 診
黃俊凱
1
NaN
17:55
NaN
2017-11-03 18:29:13.455323
6277
感染症_O1
34 診
胡婉妍
1
NaN
17:22
NaN
2017-11-03 18:29:13.455323
6278
新陳代謝_O2
36 診
曾慶孝
1
NaN
16:31
NaN
2017-11-03 18:29:13.455323
6279
血液病_O1
38 診
林耘曲
1
NaN
16:17
NaN
2017-11-03 18:29:13.455323
6280
醫師約診_O2
40 診
林亮宇
1
NaN
16:31
03;
2017-11-03 18:29:13.455323
6281
內分泌_O2
42 診
王治元
0
61.0
18:27
03;
2017-11-03 18:29:13.455323
6282
醫師約診_O2
46 診
熊育敏
0
NaN
--:--
NaN
2017-11-03 18:29:13.455323
6283
醫師約診_O2
95 診
主治醫師
0
NaN
--:--
NaN
2017-11-03 18:29:13.455323
6284
感染症_O2
98 診
主治醫師
0
NaN
--:--
NaN
2017-11-03 18:29:13.455323
6285 rows × 8 columns
In [ ]:
Content source: stuser/temp
Similar notebooks: