我有以下数据帧,我想转置它,以便列"Trans_Type"中的元素成为表示列"Trans_Amount"中的值的新列.
import pandas as pd
import numpy as np
df = pd.DataFrame([['21/10/2023','1','CR',2323],
['21/10/2023','1','CR',23],
['21/10/2023','1','DR',65],
['21/10/2023','2','CR',3.3],
['21/10/2023','3','CR',56],
['21/10/2023','3','DR',23.66],
['21/10/2023','4','CR',54.34],
['22/10/2023','4','CR',23.34],
['22/10/2023','4','DR',5.5]],
columns = ['Date','Account_Number','Trans_Type','Trns_Amount'])
df
Df输出:
Date Account_Number Trans_Type Trns_Amount
0 21/10/2023 1 CR 2323.00
1 21/10/2023 1 CR 23.00
2 21/10/2023 1 DR 65.00
3 21/10/2023 2 CR 3.30
4 21/10/2023 3 CR 56.00
5 21/10/2023 3 DR 23.66
6 21/10/2023 4 CR 54.34
7 22/10/2023 4 CR 23.34
8 22/10/2023 4 DR 5.5
预期输出:
Date Account_Number CR DR
0 21/10/2023 1 2323.00 NaN
1 21/10/2023 1 23.00 NaN
2 21/10/2023 1 NaN 65.00
3 21/10/2023 2 3.30 NaN
4 21/10/2023 3 56.00 NaN
5 21/10/2023 3 NaN 23.66
6 21/10/2023 4 54.34 NaN
7 22/10/2023 4 23.34 NaN
8 22/10/2023 4 NaN 5.50
任何帮助都是最好的. 谢谢 艾伦