如何将数据形状从(A，B)翻转到(B，A)

import numpy as np

# 定义一个2x3的矩阵
matrix = np.array([[1, 2, 3], [4, 5, 6]])

# 使用transpose()函数进行转置
transposed_matrix = np.transpose(matrix)

# 或者使用T属性进行转置
transposed_matrix = matrix.T

print(transposed_matrix)

# 定义一个2x3的矩阵
matrix = [[1, 2, 3], [4, 5, 6]]

# 获取原始矩阵的行数和列数
rows = len(matrix)
cols = len(matrix[0])

# 创建一个新的矩阵，行数为原始矩阵的列数，列数为原始矩阵的行数
transposed_matrix = [[0 for _ in range(rows)] for _ in range(cols)]

# 进行转置操作
for i in range(rows):
    for j in range(cols):
        transposed_matrix[j][i] = matrix[i][j]

print(transposed_matrix)

-- 假设有一个名为table_name的表，包含两列A和B
SELECT *
FROM table_name
PIVOT (
    MAX(B)
    FOR A IN ('A', 'B')
) AS pivoted_table;