I have a list that looks like this :
[['a', 'b', 100], ['b', 'c', 200], ['c', 'd', 300]]
And what I want to do is to convert this into Dataframe where index and columns are ['a','b','c','d'] and what I want should look like this:
-
1Welcome to Stack Overflow! What code have you tried to make your dataframe so far and what's the output?m13op22– m13op222021-03-24 14:00:12 +00:00Commented Mar 24, 2021 at 14:00
-
@BrunoPicasso If you find my solution helpful, I'd appreciate it if you mark it as the correct answer. Thank you!Albo– Albo2021-04-07 14:24:26 +00:00Commented Apr 7, 2021 at 14:24
-
1@Albo Of course! sorry my bad. I'm new hereBruno Picasso– Bruno Picasso2021-04-08 15:44:12 +00:00Commented Apr 8, 2021 at 15:44
Add a comment
|
1 Answer
With this:
import pandas as pd
import numpy as np
values = [['a', 'b', 100], ['b', 'c', 200], ['c', 'd', 300]]
col_idx = ["a", "b", "c", "d"]
x = [ord(x) - 97 for x, _, _ in values]
y = [ord(y) - 97 for _, y, _ in values]
v = [v for _, _, v in values]
A = np.zeros((len(col_idx), len(col_idx)), dtype=np.int)
A[x, y] = v
df = pd.DataFrame(A.T + A, columns=col_idx, index=col_idx)
you will get df as:
| | a | b | c | d |
|:---|----:|----:|----:|----:|
| a | 0 | 100 | 0 | 0 |
| b | 100 | 0 | 200 | 0 |
| c | 0 | 200 | 0 | 300 |
| d | 0 | 0 | 300 | 0 |
1 Comment
Bruno Picasso
Thank you! Here is my solution: ''' w = pd.DataFrame({'nombre': nombre}) w.set_index('nombre', inplace = True) df1 = pd.concat([w, pd.DataFrame(columns = nombre)]) df1 = df1.replace(np.nan, 0) for i in lista: df1[i[0]][i[1]] = i[2] df1[i[1]][i[0]] = i[2] df1''' I have previously defined the names and values via input