Pandas dataframe groupby text value that occurs in two columns

by

This seems like a graph problem.

You could try to use networkx:

import networkx as nx

G = nx.from_pandas_edgelist(df, 'v1', 'v2')

clusters = nx.connected_components(G)

output:

[{'be', 'belong'}, {'delay', 'increase', 'decrease'}, {'analyze', 'assay'},
 {'report', 'bespeak', 'circulate'}, {'induce', 'generate'}, {'trip', 'cause'},
 {'distinguish', 'isolate'}, {'infect', 'give'}, {'prove', 'result'},
 {'intercede', 'describe', 'explain'}, {'affect', 'expose'}, {'restrict', 'suppress'}]

As graph:

graph

Small function to plot the graph in jupyter:

def nxplot(G):
    from networkx.drawing.nx_agraph import to_agraph
    A = to_agraph(G)
    A.layout('dot')
    A.draw('/tmp/graph.png')
    from IPython.display import Image
    return Image(filename="/tmp/graph.png")

More Related Contents:

  1. How to write this code without using pandas?
  2. When should I (not) want to use pandas apply() in my code?
  3. How can I plot separate Pandas DataFrames as subplots?
  4. How to reversibly store and load a Pandas dataframe to/from disk
  5. Format y axis as percent
  6. float64 with pandas to_csv
  7. How do I transpose dataframe in pandas without index?
  8. How to select all columns whose names start with X in a pandas DataFrame
  9. Pandas finding local max and min
  10. How to import a text file on AWS S3 into pandas without writing to disk
  11. Append column to pandas dataframe
  12. How do I round datetime column to nearest quarter hour
  13. How to plot and annotate grouped bars in seaborn / matplotlib
  14. Print the raw value of a column alone, in pandas?
  15. Divide multiple columns by another column in pandas
  16. Access index in pandas.Series.apply
  17. Python Pandas to_sql, how to create a table with a primary key?
  18. Export Pandas DataFrame into a PDF file using Python
  19. Concat DataFrame Reindexing only valid with uniquely valued Index objects
  20. pandas – Merge nearly duplicate rows based on column value
  21. Pivot Tables or Group By for Pandas?
  22. pandas fillna not working
  23. Giving a column multiple indexes/headers
  24. How to select rows with NaN in particular column?
  25. datetime x-axis matplotlib labels causing uncontrolled overlap
  26. Normalize DataFrame by group
  27. Color a scatter plot by Column Values
  28. pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  29. pandas.read_csv FileNotFoundError: File b’\xe2\x80\xaa’ despite correct path
  30. Pandas: Selecting rows based on value counts of a particular column

Leave a Comment