【工具代码合集】

读取盘符剩余空间

import psutil

def get_disk_free_space(path):
    disk_usage = psutil.disk_usage(path)
    free_space = disk_usage.free
    return free_space

# 例子：获取C盘的剩余空间大小
path = 'C:\\'
free_space = get_disk_free_space(path)
print(f"剩余空间大小：{free_space/(1024 ** 3)} GB")
1
2
3
4
5
6
7
8
9
10
11

读取Excel

import numpy as np
import pandas as pd
import xlrd
a=0
workbook = xlrd.open_workbook('Y.xlsx')
sheet1 = workbook.sheets()[0]
dataNp = np.zeros((sheet1.nrows*sheet1.ncols, 1))
for col in range(sheet1.ncols):
    for row in range(sheet1.nrows):
        dataNp[col*1080+row][0] = sheet1.cell_value(row,col)
header=["预测值"]
pd.DataFrame(dataNp).to_csv("y_train.csv",header=header)
        
1
2
3
4
5
6
7
8
9
10
11
12
13