python濡備綍鎸夊垪鍚堝苟澶氫釜鏂囦欢
扬州沐宇科技
2021-06-01 08:03:23
python
浣跨敤python鎸夊垪鍚堝苟澶氫釜鏂囦欢鐨勬柟娉曪細1.鏂板缓python椤圭洰锛?.瀵煎叆pandas妯″潡锛?.浣跨敤pd.read鏂规硶鍒嗗埆鎵撳紑鏂囦欢锛?.浣跨敤pd.merge()鏂规硶鎸夊垪鍚堝苟鏂囦欢锛?p>
鍏蜂綋姝ラ濡備笅锛?p>1.棣栧厛锛屾墦寮€python锛屽苟鏂板缓涓€涓猵ython椤圭洰锛?p>2.python椤圭洰鍒涘缓濂藉悗锛屽湪椤圭洰涓娇鐢╥mport鏂规硶瀵煎叆pandas妯″潡锛?p>
import pandas as pd
3.pandas妯″潡瀵煎叆鍚庯紝浣跨敤pd.read鏂规硶鍒嗗埆鎵撳紑涓や釜csv鏂囦欢锛岀敤浜庢祴璇曪紱
file = pd.read_csv(u'pink.csv', encoding='gbk')
file2 = pd.read_csv('pimk2.csv', encoding='gbk')
4.鏈€鍚庯紝csv鏂囦欢鎵撳紑鍚庯紝浣跨敤pd.merge()鏂规硶鍗冲彲瀹炵幇鎸夊垪鍚堝苟涓や釜鏂囦欢锛?p>
file3 = pd.merge(file, file2, how='left', left_on=u'',right_on='WELL')
下一条：如何选择java xml的解析库
