python 实现动态行转列

python 代码

---

import pandas as pd
from collections import defaultdict
geo_df=pd.read_excel('path\geo.xlsx')
geo_dict=defaultdict(list)
for k,v in geo_df.values:
    geo_dict[k].append(v)
for i,j in geo_dict.iteritems():
    print str(i)+'|'+','.join(j) -- | 分割

geo geo_name
TC Turks and Caicos islands
TD Chad
TF French Sothern Territories
TG Togo
TH Thailand
TJ Tajikistan
TL Timor-Leste
TM Turkmenistan
TN Tunisia
TO Tonga
TP East Timor
TP East Timor a
TR Turkey
TT Trinidad And Tobago
TT Trinidad & Tobago
TV Tuvalu
TW Taiwan
TZ Tanzania, United Republic Of
TZ Tanzania
UA Ukraine
UAE UAE
UG Uganda
UM United States Minor Outlying islands
US USA
US United States
UY Uruguay
UZ Uzbekistan
VA Vatican City State
VC Saint Vincent And The Grenadines
VC St. Vincent & Grenadines
VE Venezuela
VG U.S. Virgin Islands
VG British Virgin Islands
VI Virgin islands
VN Vietnam
VU Vanuatu
WF Wallis and Futuna Islands
WS Samoa
WS Samoa Western