技术问答鎬庝箞浣跨敤pandas璇诲彇excel鏂囦欢 - 扬州沐宇科技

瑕佷娇鐢╬andas璇诲彇Excel鏂囦欢锛屽彲浠ユ寜鐓т互涓嬫楠よ繘琛屾搷浣滐細

pip install pandas

import pandas as pd

浣跨敤pd.read_excel()鍑芥暟鏉ヨ鍙朎xcel鏂囦欢銆傝鍑芥暟鎺ュ彈涓€涓瓧绗︿覆鍙傛暟锛岃〃绀篍xcel鏂囦欢鐨勮矾寰勩€備緥濡傦紝瑕佽鍙栧悕涓?code>data.xlsx鐨凟xcel鏂囦欢锛屽彲浠ヤ娇鐢ㄤ互涓嬩唬鐮侊細

data = pd.read_excel("data.xlsx")

璇ュ嚱鏁板皢Excel鏂囦欢鐨勫唴瀹瑰姞杞藉埌涓€涓猵andas鐨凞ataFrame瀵硅薄涓€?/p>

print(data.head())

浠ヤ笂灏辨槸浣跨敤pandas璇诲彇Excel鏂囦欢鐨勫熀鏈楠ゃ€備綘鍙互鏍规嵁瀹為檯闇€姹傚鏁版嵁杩涜杩涗竴姝ョ殑澶勭悊鍜屾搷浣溿€?/p>