python 数据处理操作整理

xlsx转csv

import pandas as pd
def xlsx_to_csv_pd():
    data_xls = pd.read_excel("E:\\temp\\asp.xlsx", index_col=0)
    data_xls.to_csv("E:\\temp\\Aspectj1.csv", encoding='utf-8')
xlsx_to_csv_pd()

numpy标准化

每个特征进行标准化，均值为0，方差为1

>>> a = np.arange(60).reshape((6,10))
>>> a
array([[ 0,  1,  2,  3,  4,  5,  6,  7,  8,  9],
       [10, 11, 12, 13, 14, 15, 16, 17, 18, 19],
       [20, 21, 22, 23, 24, 25, 26, 27, 28, 29],
       [30, 31, 32, 33, 34, 35, 36, 37, 38, 39],
       [40, 41, 42, 43, 44, 45, 46, 47, 48, 49],
       [50, 51, 52, 53, 54, 55, 56, 57, 58, 59]])

a -= a.mean(axis = 0)
a /= a.std(axis = 0)

求众数

忽略众数数目相同的情况

arr = array([1, 1, 1, 2, 3, 4, 1, 5])
# return_inverse=True表示返回旧列表元素在新列表中的位置，并以列表形式储存在p中。
 u, indi