Python随机抽取excel数据，并输出到txt或者word上？
写了一个，可以参考：
Word上面
绛旓細鍏堣鍙栦竴涓媏xcel琛ㄩ噷鐨勬绘暟锛岀劧鍚庨殢鏈烘娊鍙栦粠1鍒版绘暟鍏朵腑鐨勪换鎰5涓暟瀛锛岀劧鍚庢牴鎹繖5涓暟瀛楀幓excel瀵瑰簲鐨勮鍘诲彇鏁版嵁
绛旓細1銆侀鍏堣鏄庝娇鐢ㄧ殑python3.5锛宱ffice鐗堟湰鏄2010锛岄鍏堟墦寮dos鍛戒护绐楋紝瀹夎蹇呴』鐨勪袱涓簱锛屽懡浠ゆ槸锛歱ip3 install xlrd銆丳ip3 install xlwt銆2銆佸噯澶囧ソexcel锛屾墦寮pycharm锛屾柊寤轰竴涓猠xcel.py鐨勬枃浠讹紝棣栧厛瀵煎叆鏀寔搴搃mport xlrdimport xlwt銆3銆佽创鍑轰唬鐮侊紝鍏蜂綋鍒嗘瀽锛氳鎿嶄綔excel锛岄鍏堝緱鎵撳紑excel锛屼娇鐢╫pen_w...
绛旓細Python锛歩mport random import pandas as pd Cnti_dic={"A":4,"B":1,"C":3} Cntf_dic={"1":0.63,"0":0.37} df=pd.read_excel(r"D:\z.xlsx",index_col="ID")Cnti_str=""for i in Cnti_dic.items():Cnti_str+=i[0]*i[1]Cntf_str=""for j in Cntf_dic.items()...
绛旓細浣犵殑闂鍦ㄤ簬Python鐨绱㈠紩鏄粠0寮濮嬬殑锛屾墍浠ュ湪寰幆涓璬f.iloc[i - 1, 1]瀹為檯涓婂彇鐨勬槸绗琲琛岋紝绗1鍒楃殑鏁版嵁銆傚洜姝わ紝褰搃=4鏃讹紝df.iloc[3, 1]瀹為檯涓婃槸鍙栫4琛岋紝绗1鍒楃殑鏁版嵁锛屼篃灏辨槸Excel涓鐨凚5鍗曞厓鏍笺傝瑙ｅ喅杩欎釜闂锛屼綘鍙互鍦╢or寰幆涓噺鍘1锛屼互寰楀埌浣犳兂瑕佺殑B4鍗曞厓鏍肩殑鏁版嵁銆備互涓嬫槸淇敼鍚庣殑...
绛旓細1銆侀厤缃ソpython鐜鍙橀噺,杩欓噷浣跨敤鐨勬槸python3銆2銆佺幆澧冨彉閲忎腑閰嶇疆濂絧ip宸ュ叿锛屽畨瑁卲ython璋冪敤excel鎵闇瑕佺殑椹卞姩閮芥槸閫氳繃pip杩涜瀹夎鐨勩3銆佸畨瑁厁lrd妯″潡 鍛戒护锛歱ip install xlrd銆4銆佸畨瑁厁lwt妯″潡 鍛戒护锛歱ip install xlwt銆5銆侀獙璇亁lrd妯″潡锛岀敤import瀵煎叆濡傛灉娌℃姤閿欏氨琛ㄦ槑瀹夎姝ｅ父銆6銆侀獙璇亁lwt妯″潡锛岀敤import...
绛旓細python鎿嶄綔excel涓鑸槸浼氱敤鍒皒lrd涓巟lwt杩欎袱涓簱锛屼篃灏辨槸xlrd涓鸿鍙杄xcel锛寈lwt鍒欐槸鍐檈xcel鐨勫簱銆備笉杩囬渶瑕佸厛瀹夎濂絰lrd妯″潡锛屽彲浠ョ洿鎺ュ埌鍒皃ython瀹樼綉涓嬭浇锛屽綋鐒跺墠鎻愭槸宸茬粡瀹夎浜唒ython鐜銆傛澶栵紝鍦ㄥ崟鍏冩牸涓殑甯哥敤鏁版嵁绫诲瀷鏈0.empty锛堢┖鐨勶級锛1string锛坱ext锛夛紝2number锛3date锛4boolean锛5error锛6blank...
绛旓細鍐欎簡涓涓紝鍙互鍙傝冿細
绛旓細鍒嗘瀽Excel鏁版嵁锛屽叾涓渶甯哥敤鐨勬槸pandas搴撱備互涓嬫槸涓浜涘熀鏈殑姝ラ锛氬畨瑁卲andas鍜宱penpyxl搴(濡傛灉浣犺繕娌℃湁瀹夎鐨勮瘽)锛歜ash pip install pandas openpyxl 瀵煎叆pandas搴撳拰Excel鏂囦欢锛python import pandas as pd 鍔犺浇Excel鏂囦欢 df = pd.read_excel('filename.xlsx')鏌ョ湅鏁版嵁甯(DataFrame)鐨勫熀鏈俊鎭細python prin...
绛旓細姣斿璇磋嚜鍔ㄥ鍏ユ暟鎹細鎴栬闅忔満鍖归厤鏂囨湰锛氫竴銆佷负浠涔堝皢Python涓Excel VBA闆嗘垚锛烿BA浣滀负Excel鍐呯疆鐨勫畯璇█锛屽嚑涔庡彲浠ュ仛浠讳綍浜嬫儏锛屽寘鎷嚜鍔ㄥ寲銆佹暟鎹鐞嗐佸垎鏋愬缓妯＄瓑绛夛紝閭ｄ负浠涔堣鐢≒ython鏉ラ泦鎴怑xcel VBA鍛紵涓昏鏈変互涓嬩笁鐐圭悊鐢憋細濡傛灉浣犲VBA涓嶇畻绮鹃氾紝浣犲彲浠ョ洿鎺ヤ娇鐢≒ython缂栧啓鍒嗘瀽鍑芥暟鐢ㄤ簬Excel杩愮畻锛岃屾棤闇浣跨敤...
