Create adjacency matrix for two columns in pandas dataframe

by

You can use crosstab and then reindex by union of column and index values:

df = pd.crosstab(df.Name_A, df.Name_B)
print (df)
Name_B  Ben  Chris  David
Name_A                   
Adam      1      1      0
Ben       0      1      0
Chris     0      0      1

df = pd.crosstab(df.Name_A, df.Name_B)
idx = df.columns.union(df.index)
df = df.reindex(index = idx, columns=idx, fill_value=0)
print (df)
       Adam  Ben  Chris  David
Adam      0    1      1      0
Ben       0    0      1      0
Chris     0    0      0      1
David     0    0      0      0

More Related Contents:

  1. How to iterate over rows in a DataFrame in Pandas
  2. Difference between map, applymap and apply methods in Pandas
  3. Python pandas insert list into a cell
  4. How to replace text in a string column of a Pandas dataframe?
  5. Combine two pandas Data Frames (join on a common column)
  6. Pandas DataFrame Groupby two columns and get counts
  7. Pandas dataframe get first row of each group
  8. pandas .at versus .loc
  9. How to deal with multi-level column names downloaded with yfinance
  10. Replace all occurrences of a string in a pandas dataframe (Python)
  11. Running get_dummies on several DataFrame columns?
  12. Selection with .loc in python
  13. Add column to dataframe with constant value
  14. Pandas get the most frequent values of a column
  15. Subtract two columns in dataframe
  16. Python / Pandas – GUI for viewing a DataFrame or Matrix [closed]
  17. How to do “(df1 & not df2)” dataframe merge in pandas?
  18. Capitalize first letter of each word in a dataframe column
  19. Compute the running (cumulative) maximum for a series in pandas
  20. Add a sequential counter column on groups to a pandas dataframe
  21. How do I assign values based on multiple conditions for existing columns?
  22. Get total of Pandas column
  23. Python Pandas replace NaN in one column with value from corresponding row of second column
  24. Xticks by pandas plot, rename with the string
  25. Get first and second highest values in pandas columns
  26. Enumerate each row for each group in a DataFrame
  27. Pandas groupby with bin counts
  28. how to convert monthly data to quarterly in pandas
  29. How to constuct a column of data frame recursively with pandas-python?
  30. Pandas explode multiple columns [duplicate]

Leave a Comment