data = pd.read_csv(r'RE_absentee_one.csv')
data['New_addy'] = str(data['Prop-House Number']) data['Prop-Street Name'] data['Prop-Mode'] str(data['Prop-Apt Unit Number'])
df = pd.DataFrame(data, columns = ['Name','New_addy'])
所以這是代碼
如您所見，Prop-House Number 和 Prop-Apt Number 都是 int，其余都是字串，我試圖將所有這些組合起來，以便完整地址位于標有“New addy”的一列下
uj5u.com熱心網友回復：
使用 map 對每個變數進行字串賦值，如下所述：
data = pd.read_csv(r'RE_absentee_one.csv')
data['New_addy'] = data['Prop-House Number'].map(str) data['Prop-Street Name'].map(str) data['Prop-Mode'].map(str) data['Prop-Apt Unit Number'].map(str)
#select the desired columns for further work
data = data[['Name','New_addy']]
uj5u.com熱心網友回復：
一種方法是使用串列理解：
data['New_addy'] = [str(n) street mode str(apt_n) for n,street,mode,apt_n in zip(
data['Prop-House Number'],data['Prop-Street Name'],data['Prop-Mode'],data['Prop-Apt Unit Number'])]
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/483588.html