目录
1、先展示一下结果
如图,该矩阵具有行索引名和列索引名
2、具体方法:
(1) 先用numpy构造二维矩阵
(2) 再利用pandas赋予行索引名和列索引名
import pandas as pd
import numpy as np
matrix_zeros = np.zeros([16, 4])
row_index = [str([0, 1]), str([0, 2]), str([0, 3]), str([0, 4]),
str([1, 1]), str([1, 2]), str([1, 3]), str([1, 4]),
str([2, 1]), str([2, 2]), str([2, 3]), str([2, 4]),
str([3, 1]), str([3, 2]), str([3, 3]), str([3, 4])
]
columns_index = [0, 1, 2, 3]
table = pd.DataFrame(matrix_zeros, columns=columns_index, index=row_index)
print(table)
3、注意点
这里的行索引由于是列表,所以需要加str,将列表转化为字符串
4、取值
两种发法:
print(table)
print('\n')
print('Method-1')
a = table[2]['[0, 1]'] # 先列索引,再行索引
print(a)
print('\n')
print('Method-1')
b = table.loc['[0, 1]', 2] # 先行索引,再列索引
print(b)