Creating a mindmap using CSV files
I want to create a mindmap of money that I have sent and received using a CSV file with columns: from, to, money in, and money out.
I want to create a graph that shows money either moving in or out of each account, with the account I want to choose in the center.
I can't find a python library that does this. Is there a library that would let me do this? Or is that even possible using Python?
Solution
from graphviz import Digraph
import pandas as pd
import numpy as np
G = Digraph(format='jpeg')
G.attr(rankdir='LR', size='8,5')
G.attr('node', shape='circle')
df = pd.read_csv('so.csv')
# add the vertices
[G.node(str(x)) for x in np.unique(df[['From', 'To']].values.flatten())]
# add the edges
[G.edge(str(x[1][0]), str(x[1][1]), label=str(x[1][2])) for x in df.iterrows()]
G.render('sg', view=True)
Where the content of so.csv is:
From,To,Amount
Account1,Account2,20
Account1,Account3,50
Account3,Account1,60
You will have:
- Convert Categorical codes to Categorical values
- Python-Sphinx: "inherit" method documentation from superclass
- Getting Home Directory with pathlib
- How to redirect the user back to the home page using FastAPI, after submitting an HTML form?
- No FileSystem for scheme: s3 with pyspark
- How to add a state to a Selection field and show it ordered in the statusbar in Odoo 11?
- Breaking long method chains into multiple lines in Python
- Enable ruff rules only on specific files
- Filter by time in DRF
- Plotting lambda functions in Python and mpmath.plot
- How to remove Empty Rows from a list in Python 3.5
- matplotlib 3D scatter plot alpha varies when viewing different angles
- How to write very long string that conforms with PEP8 and prevent E501
- how to avoid bot detection on websites using selenium python
- Python mock to create a fake object return a dictionary when any of its attributes are used
- Polars vs. Pandas: size and speed difference
- How to mock.patch a class imported in another module
- Python - error cannot determine truth value of Relational (Newton-Raphson)
- ProcessPoolExecutor logging fails to log inside function on Windows but not on Unix / Mac
- SQLAlchemy ORM Insert or Update when importing from JSON
- django managers vs proxy models
- Pytroch clamp for complex values
- For every identifier select only rows with largest order column
- truth value for Expr is ambiguous in with_columns ternary expansion on dates
- Remove equal characters from two python strings
- Python pyad module can't set UPN
- Macro VS Micro VS Weighted VS Samples F1 Score
- Printing a Tree data structure in Python
- How to fix/reset decreasing timestamps while preserving gaps in time-series data for CNN training?
- Test that module is NOT imported