OD Matrix with freq data in pandas

Asked Sep 15 '20 at 06:03

Active Sep 15 '20 at 06:03

Viewed 16 times

Based on this post: OD Matrix

I have huge dataframe. I want to make an OD matrix. However, I have a frequency column data. The data looks like this:

print (df)

O   D   Freq
A   B   1
A   C   2
A   D   3
B   A   1
B   C   1
C   A   2
C   B   1
C   D   1
D   C   2

My desire output looks like this:

print (Dfnew)

O/D A   B   C   D
 A  0   1   2   3
 B  1   0   1   0
 C  2   1   0   1
 D  0   0   2   0

Thank you for helping me

asked Sep 15 '20 at 06:03

Arief Hidayat

1

I think you need pivoting. – jezrael Sep 15 '20 at 06:05
Forgive me @jezrael, Iam not good in python. Which kind of pivot that I can use for my data? – Arief Hidayat Sep 15 '20 at 06:11
1

I think here should be used `df = df.set_index(['O','D'])['Freq'].unstack(fill_value=0)` – jezrael Sep 15 '20 at 06:12
1

thank @jezrael, you're the best.. I will learn again about pivoting. – Arief Hidayat Sep 15 '20 at 06:18

0 Answers0