1、用python将txt文本中的数据导入excel:
https://blog.csdn.net/Cristy_Chen/article/details/105961032
2、Python读取并打印一个txt文档
f = open(r'E:\_Datasets\fer2013.csv\features\VGG19_feature_fc2_txt\00001.txt') # txt文档存储路径
text = f.readlines() # 逐行读取
print(text) # 打印
f.close()
3、Python读取文件夹下所有文档内容:
import os
import pandas as pd
path = r'E:\_Datasets\fer2013.csv\features\VGG19_feature_fc2_txt'
files = os.listdir(path)
txts = []
for file in files:
position = path + '\\' + file
print(position)
with open(position, "r", encoding = 'utf-8') as f:
data = f.read()
print(data)
4、对比excel与python 的分列处理方式:
https://blog.csdn.net/maymay_/article/details/105361091
5、将Excel批量转换为csv并合并多个csv:
将多个csv合并到一个csv中
1、将所有的csv文件放到一个文件夹中
2、打开cmd,切换到存放csv的文件夹
3、输入命令
copy *.csv 你自己起的文件名.csv
之后按回车等待完成,打开文件夹就可以看到合成的csv
https://blog.csdn.net/m0_37717751/article/details/81043721
6、python可视化学习(十四)排序图-柱状图
import matplotlib.pyplot as plt
Y_ss = [0.190947792522185,
0.172123227637411,
0.158821053838313,
0.152939706634689,
0.142670265226697,
0.124220386055618,
0.0601827838206675,
0.0500052005205166]
ss_name = ['jaw', 'right_eyebrow', 'inner_mouth', 'nose',
'left_eyebrow', 'mouth', 'left_eye', 'right_eye']
color_backup = ['r', 'r', 'r', 'b', 'b', 'b', 'b', 'b']
x = range(len(name))
plt.figure(figsize=(6, 8)) # 6,8分别是横纵画布的长度大小
# plt.barh(x,Y_ARI,height=0.5) # 水平柱状图
plt.bar(x, Y_NMI, width=0.5, color=color_backup, edgecolor='k')
plt.xticks(x, NMI_name, rotation=60, horizontalalignment='right')
# plt.yticks(x, ARI_name)
plt.tick_params(labelsize=17)
plt.title('NMI')
plt.savefig(r"D:\Python\pythonProject\lianxi\data_process\NMI.jpg", dpi=200, bbox_inches='tight')
plt.show()
参考文献:
https://blog.csdn.net/feiwenyang/article/details/121616038
7、plt.函数
https://blog.csdn.net/Fwuyi/article/details/123557841
8、python 画折线图 并标记
https://blog.csdn.net/weixin_39417324/article/details/115271218
9、优化Matplotlib显示中文为乱码的问题
from pylab import mpl
mpl.rcParams['font.sans-serif'] = ['FangSong']
mpl.rcParams['axes.unicode_minus'] = False