上海交通大学系统生物医学研究院陶生策研究员及约翰霍普金斯大学的朱衡教授和Philip A. Cole教授主要研究方向为蛋白质芯片的构建和应用,构建了世界上第一张基于纯化蛋白质的肺结核杆分枝杆菌蛋白质芯片,并以蛋白质芯片为平台在蛋白翻译后修饰方面进行了系列有影响的工作。 蛋白质是由基因所编码,蛋白质在其生命周期内往往会被打上不同类型的修饰,而且这些修饰往往也是动态变化的。蛋白质翻译后修饰会以极其精细的方式影响和调控蛋白质的功能。乙酰化作为一种重要且广泛存在的蛋白质翻译后修饰类型,与一系列重要疾病密切相关,影响众多关键的生物学过程。随着蛋白质组技术的进步,目前已经从低等的大肠杆菌到高等的人等众多生物的细胞中发现了成千上万的乙酰化修饰。蛋白质的乙酰化由乙酰转移酶和去乙酰化酶所调控。对应海量的蛋白质乙酰化修饰,目前已知的乙酰化酶和去乙酰化酶数目非常有限,仍有相当数目的新酶有待发现,一个关键问题是如何实现高效乙酰化相关酶的发现?。针对这一问题,本文作者发展了一套称之为Clip-chip的技术,在大肠杆菌蛋白质组芯片的基础上,进行了全局性蛋白质去乙酰化酶的发现,发现了一种新的去乙酰化酶YcgC。该酶能够非常高效地去除底物蛋白RutR赖氨酸52位和赖氨酸62位的乙酰化。已知的蛋白质去乙酰化酶的活性依赖于NAD+或者Zn2+,但YcgC的去乙酰化活性并不依赖于以上两者。进一步的功能实验表明,YcgC通过去乙酰化影响RutR的转录调控活性。在实验中作者还发现RutR具有蛋白酶活性,YcgC通过去乙酰化能够调节RutR的蛋白酶活性。作者比较了YcgC与大肠杆菌中唯一的去乙酰化酶CobB对大肠杆菌表达谱的影响,结果表明,两者既有相似点,也有较大的不同,提示YcgC的底物谱与CobB的可能有较大的不同。通过全基因合成,作者获得了来源于多个其它细菌的大肠杆菌YcgC的同源基因克隆,表达测试表明这些克隆所表达的蛋白均具有蛋白质去乙酰化酶活性。 本研究所发现的YcgC可能代表一个全新的蛋白质去乙酰化酶家族。同时本研究中所发展的Clip-Chip技术具有通用性,可方便地移植于其它酶的发现中。
2014世界大学学术(化学)排名Top200,中国入围高校知多少(修改稿)? 诸平 2014年8月15日,上海交通大学世界一流大学研究中心正式发布2014年“ 世界大学学术排名 ”,排名列出了全球领先的500所研究型大学,中国内地共有32所大学上榜,相比去年增加了4所,其中清华大学、北京大学等6所学校进入世界前200名(共有58所中国大学入围TOP200,见下表统计结果)。就化学学科而言,中国有30所高校进入TOP200之列。其中北京大学排名最靠前(世界TOP200排名28)、其次是浙江大学(世界排名46)、复旦大学(世界排名49):华东理工大学、吉林大学、南京大学、中山大学、清华大学(台湾)、清华大学(北京)以及厦门大学世界并列排名第51-75;大连理工大学、湖南大学、南开大学和中国科技大学世界并列排名第76-100;香港城市大学、兰州大学、台湾大学、东北师范大学、上海大学、上海交通大学、四川大学、苏州大学、香港中文大学、香港科技大学、香港大学、天津大学以及武汉大学并列世界排名101-150;华东师范大学、福州大学以及华南理工大学并列世界排名第151-200,其他国家的化学学科入围世界大学学术排名top200的高校详见下表: Academic Ranking of World Universities in Chemistry - 2014 Mathematics Physics Chemistry Computer Economics Methodology Statistics World Rank Institution Country /Region Total Score Score on Alumni Award HiCi PUB TOP 1 University of California-Berkeley 100 94.3 2 Harvard University 96.5 100 3 Stanford University 95.8 57.7 4 Northwestern University 84.6 0 5 University of Cambridge 83.4 66.7 6 Massachusetts Institute of Technology (MIT) 82.9 0 7 California Institute of Technology 80.8 0 8 Swiss Federal Institute of Technology Zurich 77 33.3 9 Kyoto University 76.9 33.3 10 University of California, Los Angeles 72.9 0 11 University of Pennsylvania 72 57.7 12 Yale University 70.3 57.7 13 University of California, Santa Barbara 70.1 0 14 University of Oxford 67.7 33.3 15 Columbia University 67.6 47.1 16 Technical University Munich 66.7 66.7 17 University of Strasbourg 66.4 33.3 18 Rice University 65.9 0 18 University of California, San Diego 65.9 0 20 The University of Tokyo 65 0 21 Purdue University - West Lafayette 64.9 0 21 University of Toronto 64.9 0 23 Georgia Institute of Technology 64.3 33.3 24 The University of Texas at Austin 64.2 0 25 Swiss Federal Institute of Technology Lausanne 63.8 0 26 University of California, Irvine 63.4 0 27 University of Michigan-Ann Arbor 61.7 33.3 28 Peking University 61.5 0 29 University of Minnesota, Twin Cities 60.8 0 30 University of Wuerzburg 60 47.1 31 University of Illinois at Urbana-Champaign 59.9 0 32 University of Colorado at Boulder 59.3 33.3 33 University of North Carolina at Chapel Hill 58.9 0 34 Tohoku University 58.4 57.7 35 Osaka University 58.3 0 35 University of Florida 58.3 33.3 37 Heidelberg University 57.6 0 38 King Abdulaziz University 57.4 0 39 University of Wisconsin - Madison 57.3 0 40 Cornell University 56.9 0 41 Texas A M University 56.7 0 42 University of Southern California 56.4 0 43 Weizmann Institute of Science 56.2 47.1 44 University of Muenster 56.1 0 45 Monash University 56 0 46 Zhejiang University 55.9 0 47 University of California, Riverside 55.7 33.3 48 Nagoya University 55.6 0 49 Fudan University 55.5 0 50 Tokyo Institute of Technology 55.3 33.3 51-75 Aarhus University 0 51-75 East China University of Science and Technology 0 51-75 Hokkaido University 0 51-75 Indian Institute of Science 0 51-75 Jilin University 0 51-75 King Abdullah University of Science and Technology 0 51-75 Nanjing University 0 51-75 Nanyang Technological University 0 51-75 National Tsing Hua University 33.3 51-75 Polytechnic University of Valencia 0 51-75 RWTH Aachen University 0 51-75 Seoul National University 0 51-75 Stockholm University 47.1 51-75 Sun Yat-sen University 0 51-75 The Hebrew University of Jerusalem 66.7 51-75 The Imperial College of Science, Technology and Medicine 0 51-75 The Johns Hopkins University 47.1 51-75 Tsinghua University 0 51-75 University of California, Davis 0 51-75 University of Erlangen-Nuremberg 0 51-75 University of Goettingen 0 51-75 University of Groningen 0 51-75 University of Ottawa 0 51-75 University of Pittsburgh-Pittsburgh Campus 0 51-75 Xiamen University 0 76-100 Carnegie Mellon University 0 76-100 Dalian University of Technology 0 76-100 Duke University 0 76-100 Hunan University 0 76-100 Indiana University Bloomington 0 76-100 Iowa State University 0 76-100 Karlsruhe Institute of Technology (KIT) 0 76-100 Kyushu University 0 76-100 Nankai University 0 76-100 National University of Singapore 0 76-100 Pennsylvania State University - University Park 0 76-100 Pohang University of Science and Technology 0 76-100 Princeton University 47.1 76-100 State University of New York at Buffalo 0 76-100 The Ohio State University - Columbus 0 76-100 University of British Columbia 0 76-100 University of Chicago 0 76-100 University of Notre Dame 0 76-100 University of Science and Technology of China 0 76-100 University of Southampton 0 76-100 University of Stuttgart 33.3 76-100 University of Sydney 0 76-100 University of Zaragoza 0 76-100 Utrecht University 0 76-100 Washington University in St. Louis 0 101-150 Cardiff University 0 101-150 City University of Hong Kong 0 101-150 Colorado State University 0 101-150 Eindhoven University of Technology 0 101-150 Emory University 0 101-150 Ewha Womans University 0 101-150 King Saud University 0 101-150 Korea Advanced Institute of Science and Technology 0 101-150 Korea University 0 101-150 Lanzhou University 0 101-150 Lund University 0 101-150 McGill University 0 101-150 National Taiwan University 0 101-150 Northeast Normal University 0 101-150 Pierre and Marie Curie University - Paris 6 0 101-150 Shandong University 0 101-150 Shanghai Jiao Tong University 0 101-150 Sichuan University 0 101-150 Soochow University 0 101-150 Technical University of Berlin 0 101-150 Technion-Israel Institute of Technology 81.6 101-150 The Chinese University of Hong Kong 0 101-150 The Hong Kong University of Science and Technology 0 101-150 The University of Georgia 0 101-150 The University of Hong Kong 0 101-150 The University of Manchester 0 101-150 The University of New South Wales 0 101-150 The University of Queensland 0 101-150 The University of Western Australia 0 101-150 Tianjin University 0 101-150 University College London 0 101-150 University of Barcelona 0 101-150 University of Basel 33.3 101-150 University of Bath 0 101-150 University of Bologna 0 101-150 University of Bonn 0 101-150 University of Bristol 0 101-150 University of Delaware 0 101-150 University of Florence 0 101-150 University of Massachusetts Amherst 0 101-150 University of Nottingham 0 101-150 University of Rostock 0 101-150 University of Tennessee - Knoxville 0 101-150 University of Utah 0 101-150 University of Valencia 0 101-150 University of Washington 0 101-150 University of Waterloo 0 101-150 Uppsala University 0 101-150 Wuhan University 0 101-150 Yonsei University 0 151-200 Arizona State University 0 151-200 Autonomous University of Barcelona 0 151-200 Autonomous University of Madrid 0 151-200 Claude Bernard University Lyon 1 0 151-200 Complutense University of Madrid 0 151-200 Durham University 0 151-200 East China Normal University 0 151-200 Florida State University 0 151-200 Fuzhou University 0 151-200 Ghent University 0 151-200 Joseph Fourier University (Grenoble 1) 0 151-200 KU Leuven 0 151-200 Newcastle University 0 151-200 Paul Sabatier University (Toulouse 3) 0 151-200 Queen's University 0 151-200 South China University of Technology 0 151-200 Sungkyunkwan University 0 151-200 Technical University of Braunschweig 0 151-200 Tel Aviv University 0 151-200 The University of Calgary 0 151-200 The University of Edinburgh 0 151-200 The University of Sheffield 33.3 151-200 University of Alberta 0 151-200 University of Alicante 0 151-200 University of Bern 33.3 151-200 University of Bochum 0 151-200 University of Bordeaux 0 151-200 University of Copenhagen 0 151-200 University of Freiburg 33.3 151-200 University of Geneva 0 151-200 University of Houston 0 151-200 University of Liverpool 0 151-200 University of Mainz 0 151-200 University of Marburg 0 151-200 University of Maryland, College Park 0 151-200 University of Missouri - Columbia 0 151-200 University of Munich 0 151-200 University of Oviedo 0 151-200 University of Paris Sud (Paris 11) 0 151-200 University of Rennes 1 0 151-200 University of South Florida 0 151-200 University of St Andrews 0 151-200 University of Trieste 0 151-200 University of Tsukuba 0 151-200 University of Tuebingen 47.1 151-200 University of Twente 0 151-200 University of Virginia 0 151-200 University of Warwick 0 151-200 VU University Amsterdam 0 151-200 Wayne State University 0 * Institutions within the same rank range are listed alphabetically. Top 200 Region Mathematics Physics Chemistry Computer Science Economics Business United States 59 62 58 67 99 China 36 8 30 34 12 United Kingdom 8 20 17 16 19 Germany 11 17 19 4 5 France 16 12 8 5 2 Canada 7 6 8 8 13 Spain 10 4 9 10 6 Italy 13 14 3 4 2 Australia 4 6 5 8 8 Netherlands — 5 5 8 7 Japan 4 8 9 1 1 Switzerland 4 6 5 2 4 Israel 3 4 4 6 2 South Korea 3 1 7 4 2 Belgium 1 3 2 3 3 Denmark 2 1 2 2 4 Sweden — 4 3 1 3 Saudi Arabia 3 1 3 2 — Singapore 1 2 2 2 2 Norway 2 1 — 2 2 Austria 1 2 — 1 1 Brazil 2 1 — 2 — Chile 1 1 — — 1 Finland 1 1 — — 1 Greece — 1 — 2 — India — — 1 2 — Iran — — — 3 — Portugal 1 1 — 1 — Russia 2 1 — — — Czech 1 1 — — — New Zealand 1 — — — 1 Serbia 1 1 — — — Hungary — 1 — — — Malaysia 1 — — — — Mexico — 1 — — — Poland — 1 — — — Romania 1 — — — — South Africa — 1 — — — Turkey — 1 — — — Total 200 200 200 200 200 Statistics by Institution and Field Institution* Country/Region Top 20 Top 100 Top 200 Harvard University United States 5 5 5 Massachusetts Institute of Technology (MIT) United States 5 5 5 Stanford University United States 5 5 5 University of California-Berkeley United States 5 5 5 Columbia University United States 4 5 5 Princeton University United States 4 5 5 University of California, Los Angeles United States 4 5 5 University of Cambridge United Kingdom 4 5 5 University of Michigan-Ann Arbor United States 4 5 5 University of California, San Diego United States 3 5 5 University of Oxford United Kingdom 3 5 5 Swiss Federal Institute of Technology Zurich Switzerland 3 4 5 California Institute of Technology United States 3 4 4 Carnegie Mellon University United States 2 5 5 Cornell University United States 2 5 5 Duke University United States 2 5 5 Northwestern University United States 2 5 5 University of Pennsylvania United States 2 5 5 Yale University United States 2 5 5 The University of Tokyo Japan 2 4 5 University of California, Santa Barbara United States 2 4 5 University of Minnesota, Twin Cities United States 2 4 5 University of Chicago United States 2 4 4 Kyoto University Japan 2 3 3 Texas A M University United States 1 5 5 The Johns Hopkins University United States 1 5 5 The University of Texas at Austin United States 1 5 5 University of Colorado at Boulder United States 1 5 5 University of Illinois at Urbana-Champaign United States 1 5 5 University of Toronto Canada 1 5 5 University of Wisconsin - Madison United States 1 5 5 Georgia Institute of Technology United States 1 4 5 Rice University United States 1 4 5 The Imperial College of Science, Technology and Medicine United Kingdom 1 4 5 University of Maryland, College Park United States 1 4 5 University of Washington United States 1 4 5 Technical University Munich Germany 1 3 5 Tel Aviv University Israel 1 3 5 The University of Manchester United Kingdom 1 3 5 King Abdulaziz University Saudi Arabia 1 3 4 New York University United States 1 3 4 University of Southern California United States 1 3 4 Pierre and Marie Curie University - Paris 6 France 1 2 4 Technion-Israel Institute of Technology Israel 1 2 4 The University of Edinburgh United Kingdom 1 2 4 University of Paris Sud (Paris 11) France 1 2 4 University of Arizona United States 1 2 3 University of Munich Germany 1 1 4 University of Strasbourg France 1 1 2 London School of Economics and Political Science United Kingdom 1 1 1 Pennsylvania State University - University Park United States — 5 5 The Hebrew University of Jerusalem Israel — 5 5 The Ohio State University - Columbus United States — 5 5 University of California, Irvine United States — 5 5 Peking University China — 4 5 Purdue University - West Lafayette United States — 4 5 University of Bonn Germany — 4 5 University of British Columbia Canada — 4 5 University of California, Davis United States — 4 5 Brown University United States — 4 4 Rutgers, The State University of New Jersey - New Brunswick United States — 4 4 University of North Carolina at Chapel Hill United States — 4 4 National University of Singapore Singapore — 3 5 Tsinghua University China — 3 5 University College London United Kingdom — 3 5 University of Florida United States — 3 5 Boston University United States — 3 4 Indiana University Bloomington United States — 3 4 Michigan State University United States — 3 4 Swiss Federal Institute of Technology Lausanne Switzerland — 3 4 The Chinese University of Hong Kong Hong Kong — 3 4 University of Bristol United Kingdom — 3 4 University of Utah United States — 3 4 Zhejiang University China — 3 4 Ecole Normale Superieure - Paris France — 3 3 University of Amsterdam Netherlands — 3 3 University of Zurich Switzerland — 3 3 Weizmann Institute of Science Israel — 3 3 Iowa State University United States — 2 5 KU Leuven Belgium — 2 5 McGill University Canada — 2 5 Seoul National University South Korea — 2 5 Shanghai Jiao Tong University China — 2 5 University of Copenhagen Denmark — 2 5 University of Houston United States — 2 5 University of Massachusetts Amherst United States — 2 5 University of Sydney Australia — 2 5 University of Virginia United States — 2 5 University of Warwick United Kingdom — 2 5 Arizona State University United States — 2 4 City University of Hong Kong Hong Kong — 2 4 Monash University Australia — 2 4 Nanyang Technological University Singapore — 2 4 The University of Melbourne Australia — 2 4 The University of New South Wales Australia — 2 4 University of Groningen Netherlands — 2 4 University of Montreal Canada — 2 4 University of Notre Dame United States — 2 4 University of Oslo Norway — 2 4 University of Pittsburgh-Pittsburgh Campus United States — 2 4 University of Science and Technology of China China — 2 4 Utrecht University Netherlands — 2 4 Vanderbilt University United States — 2 4 Aarhus University Denmark — 2 3 Autonomous University of Madrid Spain — 2 3 Heidelberg University Germany — 2 3 Sun Yat-sen University China — 2 3 The Hong Kong Polytechnic University Hong Kong — 2 3 The Hong Kong University of Science and Technology Hong Kong — 2 3 Tokyo Institute of Technology Japan — 2 3 University of Alberta Canada — 2 3 University of Geneva Switzerland — 2 3 University of Muenster Germany — 2 3 University of Roma - La Sapienza Italy — 2 3 Aix Marseille University France — 2 2 Fudan University China — 2 2 Harbin Institute of Technology China — 2 2 Karlsruhe Institute of Technology (KIT) Germany — 2 2 McMaster University Canada — 2 2 Moscow State University Russia — 2 2 Nagoya University Japan — 2 2 Osaka University Japan — 2 2 Tohoku University Japan — 2 2 University of Granada Spain — 2 2 University of Rochester United States — 2 2 University of Vienna Austria — 2 2 University Paris Diderot - Paris 7 France — 2 2 Washington University in St. Louis United States — 2 2 Ghent University Belgium — 1 4 Nanjing University China — 1 4 National Taiwan University Taiwan — 1 4 Polytechnic University of Valencia Spain — 1 4 RWTH Aachen University Germany — 1 4 The Australian National University Australia — 1 4 The University of Sheffield United Kingdom — 1 4 University of Waterloo Canada — 1 4 Dalian University of Technology China — 1 3 Ecole Polytechnique France — 1 3 North Carolina State University - Raleigh United States — 1 3 State University of New York at Buffalo United States — 1 3 Stockholm University Sweden — 1 3 Stony Brook University United States — 1 3 The University of Hong Kong Hong Kong — 1 3 University of Birmingham United Kingdom — 1 3 University of Bologna Italy — 1 3 University of Illinois at Chicago United States — 1 3 University of Sao Paulo Brazil — 1 3 University of Southampton United Kingdom — 1 3 University of Stuttgart Germany — 1 3 VU University Amsterdam Netherlands — 1 3 Xian Jiao Tong University China — 1 3 Durham University United Kingdom — 1 2 Eindhoven University of Technology Netherlands — 1 2 Emory University United States — 1 2 Huazhong University of Science and Technology China — 1 2 Indian Institute of Science India — 1 2 Jilin University China — 1 2 Joseph Fourier University (Grenoble 1) France — 1 2 Korea Advanced Institute of Science and Technology South Korea — 1 2 Lanzhou University China — 1 2 Leiden University Netherlands — 1 2 Nankai University China — 1 2 National Sun Yat-Sen University Taiwan — 1 2 National Tsing Hua University Taiwan — 1 2 Northeastern University United States — 1 2 Simon Fraser University Canada — 1 2 Southeast University China — 1 2 Technical University of Berlin Germany — 1 2 The University of Georgia United States — 1 2 The University of Texas at Dallas United States — 1 2 University of California, Riverside United States — 1 2 University of Frankfurt Germany — 1 2 University of Goettingen Germany — 1 2 University of Hawaii at Manoa United States — 1 2 University of Lisbon Portugal — 1 2 University of Milan Italy — 1 2 University of Nebraska - Lincoln United States — 1 2 University of Padua Italy — 1 2 University of Pisa Italy — 1 2 University of Pompeu Fabra Spain — 1 2 University of Sussex United Kingdom — 1 2 University of Victoria Canada — 1 2 University of Wuerzburg Germany — 1 2 University of Zaragoza Spain — 1 2 Uppsala University Sweden — 1 2 Xiamen University China — 1 2 Boston College United States — 1 1 Brigham Young University United States — 1 1 Copenhagen Business School Denmark — 1 1 Dartmouth College United States — 1 1 East China University of Science and Technology China — 1 1 Erasmus University Netherlands — 1 1 University Libre Bruxelles Belgium — 1 1 George Mason University United States — 1 1 Georgetown University United States — 1 1 Georgia State University United States — 1 1 Gyeongsang National University South Korea — 1 1 Hokkaido University Japan — 1 1 Humboldt University of Berlin Germany — 1 1 Hunan University China — 1 1 INSEAD France — 1 1 King Abdullah University of Science and Technology Saudi Arabia — 1 1 King Fahd University of Petroleum Minerals Saudi Arabia — 1 1 Kyushu University Japan — 1 1 London Business School United Kingdom — 1 1 National Chiao Tung University Taiwan — 1 1 New Jersey Institute of Technology United States — 1 1 Norwegian University of Science and Technology - NTNU Norway — 1 1 Pohang University of Science and Technology South Korea — 1 1 Radboud University Nijmegen Netherlands — 1 1 Swinburne University of Technology Australia — 1 1 Temple University United States — 1 1 Tianjin Polytechnic University China — 1 1 Tilburg University Netherlands — 1 1 University of Arkansas at Fayetteville United States — 1 1 University of California, Santa Cruz United States — 1 1 University of Erlangen-Nuremberg Germany — 1 1 University of Hamburg Germany — 1 1 University of Hannover Germany — 1 1 University of Innsbruck Austria — 1 1 University of Jaen Spain — 1 1 University of Leicester United Kingdom — 1 1 University of Miami United States — 1 1 University of Ottawa Canada — 1 1 University of Paris Dauphine (Paris 9) France — 1 1 University of Santiago Compostela Spain — 1 1 University of South Carolina - Columbia United States — 1 1 Vienna University of Technology Austria — 1 1 Western University (The University of Western Ontario) Canada — 1 1 Xidian University China — 1 1 Autonomous University of Barcelona Spain — — 4 University of Bordeaux France — — 4 University of Iowa United States — — 4 University of Tennessee - Knoxville United States — — 4 Claude Bernard University Lyon 1 France — — 3 Colorado State University United States — — 3 Florida State University United States — — 3 Hong Kong Baptist University Hong Kong — — 3 King Saud University Saudi Arabia — — 3 Korea University South Korea — — 3 Paul Sabatier University (Toulouse 3) France — — 3 Rensselaer Polytechnic Institute United States — — 3 Shandong University China — — 3 The University of Calgary Canada — — 3 The University of Queensland Australia — — 3 University of Delaware United States — — 3 University of Nottingham United Kingdom — — 3 University of South Florida United States — — 3 University of Tuebingen Germany — — 3 University of Valencia Spain — — 3 Wayne State University United States — — 3 Wuhan University China — — 3 Yonsei University South Korea — — 3 Carlos III University of Madrid Spain — — 2 Catholic University of Chile Chile — — 2 Charles University in Prague Czech — — 2 Clemson University United States — — 2 Complutense University of Madrid Spain — — 2 East China Normal University China — — 2 Lund University Sweden — — 2 National and Kapodistrian University of Athens Greece — — 2 Northeast Normal University China — — 2 Oklahoma State University United States — — 2 Oregon State University United States — — 2 Polytechnic Institute of Milan Italy — — 2 Polytechnic University of Catalonia Spain — — 2 Polytechnic University of Turin Italy — — 2 Queen's University Canada — — 2 Royal Institute of Technology Sweden — — 2 Scuola Normale Superiore - Pisa Italy — — 2 Sichuan University China — — 2 The University of Auckland New Zealand — — 2 The University of Glasgow United Kingdom — — 2 The University of Western Australia Australia — — 2 University of Barcelona Spain — — 2 University of Basel Switzerland — — 2 University of Belgrade Serbia — — 2 University of Bern Switzerland — — 2 University of Campinas Brazil — — 2 University of Electronic Science and Technology of China China — — 2 University of Essex United Kingdom — — 2 University of Florence Italy — — 2 University of Freiburg Germany — — 2 University of Helsinki Finland — — 2 University of Kansas United States — — 2 University of Leeds United Kingdom — — 2 University of Liverpool United Kingdom — — 2 University of Mainz Germany — — 2 University of Missouri - Columbia United States — — 2 University of Oklahoma - Norman United States — — 2 University of Pavia Italy — — 2 University of Rennes 1 France — — 2 University of Roma - Tor Vergata Italy — — 2 University of Seville Spain — — 2 University of St Andrews United Kingdom — — 2 University of Technology, Sydney Australia — — 2 University of Trieste Italy — — 2 University of Tsukuba Japan — — 2 University of Twente Netherlands — — 2 Virginia Polytechnic Institute and State University United States — — 2 Waseda University Japan — — 2 Aalto University Finland — — 1 Amirkabir University of Technology Iran — — 1 Aston University United Kingdom — — 1 Babes-Bolyai University Romania — — 1 Bar-Ilan University Israel — — 1 Beihang University China — — 1 Beijing Normal University China — — 1 Ben-Gurion University of the Negev Israel — — 1 Bielefeld University Germany — — 1 Bocconi University Italy — — 1 Bogazici University Turkey — — 1 Cardiff University United Kingdom — — 1 Catholic University of Louvain Belgium — — 1 Central South University China — — 1 Chongqing University China — — 1 City University London United Kingdom — — 1 City University New York - Baruch College United States — — 1 Concordia University Canada — — 1 Delft University of Technology Netherlands — — 1 Drexel University United States — — 1 Ecole Normale Superieure - Lyon France — — 1 Eotvos Lorand University Hungary — — 1 Ewha Womans University South Korea — — 1 Fuzhou University China — — 1 Griffith University Australia — — 1 HEC Paris France — — 1 Indian Statistical Institute India — — 1 International School for Advanced Studies Italy — — 1 Kaohsiung Medical University Taiwan — — 1 King's College London United Kingdom — — 1 Lancaster University United Kingdom — — 1 Louisiana State University - Baton Rouge United States — — 1 Maastricht University Netherlands — — 1 Memorial University of Newfoundland Canada — — 1 Miami University-Oxford United States — — 1 National Autonomous University of Mexico Mexico — — 1 National Central University Taiwan — — 1 National Cheng Kung University Taiwan — — 1 National Taiwan University of Science and Technology Taiwan — — 1 National Technical University of Athens Greece — — 1 National University of Defense Technology China — — 1 National University of Malaysia Malaysia — — 1 Newcastle University United Kingdom — — 1 NHH - Norwegian School of Economics Norway — — 1 Northeastern University China — — 1 Northwestern Polytechnical University China — — 1 Paris 13 University France — — 1 Polytechnic University of Madrid Spain — — 1 Queen Mary, University of London United Kingdom — — 1 Saint Petersburg State University Russia — — 1 Shanghai Normal University China — — 1 Shanghai University China — — 1 Shanghai University of Finance and Economics China — — 1 Sharif University of Technology Iran — — 1 Soochow University China — — 1 South China Normal University China — — 1 South China University of Technology China — — 1 Southern Methodist University United States — — 1 Southwest Jiaotong University China — — 1 Stockholm School of Economics Sweden — — 1 Sungkyunkwan University South Korea — — 1 Swansea University United Kingdom — — 1 Syracuse University United States — — 1 Technical University Darmstadt Germany — — 1 Technical University of Braunschweig Germany — — 1 Technical University of Denmark Denmark — — 1 Texas Christian University United States — — 1 Texas Tech University United States — — 1 The George Washington University United States — — 1 The University of Adelaide Australia — — 1 The University of Alabama - Tuscaloosa United States — — 1 The University of Memphis United States — — 1 Tianjin University China — — 1 Tongji University China — — 1 Tulane University United States — — 1 University of Alicante Spain — — 1 University of Antwerp Belgium — — 1 University of Auvergne France — — 1 University of Bath United Kingdom — — 1 University of Bergen Norway — — 1 University of Bochum Germany — — 1 University of Calabria Italy — — 1 University of Cape Town South Africa — — 1 University of Catania Italy — — 1 University of Central Florida United States — — 1 University of Cergy-Pontoise France — — 1 University of Chile Chile — — 1 University of Connecticut United States — — 1 University of East Anglia United Kingdom — — 1 University of Exeter United Kingdom — — 1 University of Genova Italy — — 1 University of Gothenburg Sweden — — 1 University of La Laguna Spain — — 1 University of Lausanne Switzerland — — 1 University of Lorraine France — — 1 University of Mannheim Germany — — 1 University of Marburg Germany — — 1 University of Milan - Bicocca Italy — — 1 University of Minho Portugal — — 1 University of Naples Federico II Italy — — 1 University of Nice Sophia Antipolis France — — 1 University of Oregon United States — — 1 University of Oviedo Spain — — 1 University of Parma Italy — — 1 University of Rostock Germany — — 1 University of Southern Denmark Denmark — — 1 University of St.Gallen Switzerland — — 1 University of Surrey United Kingdom — — 1 University of Tehran Iran — — 1 University of the Basque Country Spain — — 1 University of Trento Italy — — 1 University of Turin Italy — — 1 University of Valladolid Spain — — 1 University of Warsaw Poland — — 1 University of Wuppertal Germany — — 1 University Rovira i Virgili Spain — — 1 Vienna University of Economics and Business Administration Austria — — 1 York University Canada — — 1
# 统计每一年晴、雨、多云、阴、雪、雾霾、沙尘的天数, # 统计每一年持续1天、2天、3天、 上雾霾的次数,并绘制成柱状图 # 根据前一天的天气情况预测第二天是否会降水 #%% import pandas import matplotlib.pyplot as matpyplot data=pandas.read_excel(' Weather .xlsx') for j in range(7): Shine=0 Rain=0 Cloud=0 Overcast=0 Snow=0 Haze=0 Sand=0 year=list() for i in data.index: if '{}'.format(2011+j) in data.ix : year.append(data.ix ) if '晴' in data.ix : Shine+=1 if '雨' in data.ix : Rain+=1 if '多云' in data.ix : Cloud+=1 if '阴' in data.ix : Overcast+=1 if '雪' in data.ix : Snow+=1 if '霾' in data.ix : Haze+=1 if '尘' in data.ix : Sand+=1 matpyplot.subplot(3,3,j+1) labels='Shine','Sand','Rain','Snow','Cloud','Overcast','Haze' l=len(year) #%% import pandas import numpy import matplotlib.pyplot as matpyplot data=pandas.read_excel(' Weather .xlsx') data_sort=data.sort_values(by='日期') date=data_sort.日期 tianqi=data_sort.天气 day_one=list() day_two=list() day_three=list() day_four=list() day_five=list() for j in range(7): m=1 days=list() bools=list() for index in list(date): bools.append('{}'.format(j+2011) in index) date_year=list(tianqi ) for i in range(len(date_year)): if i+1len(date_year): if '霾' in date_year : if '霾' in date_year : m+=1 continue else: days.append(m) m=1 else: continue elif '霾' in date_year : days.append(m) day_one.append(days.count(1)) day_two.append(days.count(2)) day_three.append(days.count(3)) day_four.append(days.count(4)) day_five.append(len(days)-days.count(1)-days.count(2)-days.count(3)-days.count(4)) groups=7 index=numpy.arange(groups) bar_width=0.2 matpyplot.bar(index,day_one,bar_width,alpha=0.5,label='1 day') matpyplot.bar(index+bar_width,day_two,bar_width,alpha=0.5,label='2 days') matpyplot.bar(index+2*bar_width,day_three,bar_width,alpha=0.5,label='3 days') matpyplot.bar(index+3*bar_width,day_four,bar_width,alpha=0.5,label='4 days') matpyplot.bar(index+4*bar_width,day_five,bar_width,alpha=0.5,label=' =5 days') #%% data=pandas.read_excel(' Weather .xlsx') data_sort=data.sort_values(by='日期') Weather=data_sort.天气 List_Weather=list(Weather) Weather_num=list() List_Rain=list() for i in List_Weather: if '雨' in i or '雪' in i: List_Rain.append(1) else: List_Rain.append(0) Weather_array= if '晴' in i: Weather_array =1 if '雨' in i: Weather_array =1 if '雪' in i: Weather_array =1 if '多云' in i: Weather_array =1 if '阴' in i: Weather_array =1 if '霾' in i: Weather_array =1 if '尘' in i: Weather_array =1 Weather_num.append(Weather_array) del Weather_num del List_Rain # LogisticRegression from sklearn.linear_model import LogisticRegression lr=LogisticRegression() lr.fit(Weather_num,List_Rain) print('LogisticRegression 采用训练数据测试分数为:{}'.format(lr.score(Weather_num,List_Rain))) # LogisticRegression from sklearn.cross_validation import cross_val_score lr=LogisticRegression() scores=cross_val_score(lr,Weather_num,List_Rain,cv=5,scoring='accuracy') print('LogisticRegression 5折交叉验证分数:{}'.format(scores.mean())) ************************** #%%