1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| import pandas as pd
ClinicalMedicineInstitutions = ['HARVARD UNIVERSITY', 'JOHNS HOPKINS UNIVERSITY', 'SHANGHAI JIAO TONG UNIVERSITY', 'UNIVERSITY OF CALIFORNIA SAN DIEGO', 'SUN YAT SEN UNIVERSITY', 'FUDAN UNIVERSITY', 'PEKING UNIVERSITY', 'UNIVERSITY OF TOKYO', 'CAPITAL MEDICAL UNIVERSITY', 'CHINESE ACADEMY OF MEDICAL SCIENCES - PEKING UNION MEDICAL COLLEGE', 'SICHUAN UNIVERSITY', 'ZHEJIANG UNIVERSITY', 'HUAZHONG UNIVERSITY OF SCIENCE & TECHNOLOGY', 'UNIVERSITY OF HONG KONG', 'CHINESE UNIVERSITY OF HONG KONG'] RawData = pd.DataFrame(pd.read_excel('CLINICAL MEDICINE.xlsx', header=5, usecols=[1, 3, 4, 5], skipfooter=1)) SortByDocs = RawData.sort_values(by="Web of Science Documents", ascending=False) SortByDocs['DOCS_Rank']= range(1,len(SortByDocs)+1) SortByCites = SortByDocs.sort_values(by="Cites", ascending=False) SortByCites['CITES_Rank']= range(1,len(SortByCites)+1) SortByCitesDivDocs = SortByCites.sort_values(by="Cites/Paper", ascending=False) SortByCitesDivDocs['Cites/Papers_Rank'] = range(1,len(SortByCitesDivDocs)+1) InstitutionsFilter_SortByCitesDivDocs = SortByCitesDivDocs[SortByCitesDivDocs.Institutions.isin(ClinicalMedicineInstitutions)] InstitutionsFilter_SortByCitesDivDocs = InstitutionsFilter_SortByCitesDivDocs.sort_values(by="Web of Science Documents", ascending=False) InstitutionsFilter_SortByCitesDivDocs.to_excel('临床医学统计结果.xlsx',index=False)
|