Create ERD diagrams from pandas dataframes.
Project description
Create ERD diagram from pandas dataframes
- create an ERD object and add tables and connections between tables
- save the generated dot code to an
output.txt
file containing - copy-paste the
output.txt
into a graphviz rendering tool like this one - the output image at the bottom is generated by using the above link
Example usage:
import pandas as pd
from pandaserd import ERD
df1 = pd.DataFrame(data=[[123, 32, '1 Ottawa Street'], [123, 80, '14 Canada Road']])
df1.columns = ['PERSON', 'AGE', 'ADDRESS']
df2 = pd.DataFrame(data=[[6342, 124123124124, '1992-01-02', 'K012V4'], [3124, 154823124124, '1984-02-02', 'L4Y6S2']])
df2.columns = ['PERSON', 'CREDIT_CARD', 'DOB', 'POSTAL_CODE']
erd = ERD()
erd.add_table(df1, 'PERSON')
erd.add_table(df2, 'CREDIT_CARD')
erd.create_edge('PERSON', 'CREDIT_CARD', left_on='PERSON', right_on='PERSON', right_cardinality='*')
erd.write_to_file('output.txt')
Credits
Largely inspired by this fab repo!
- dot documentation can be found here
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
pandaserd-0.1.2.tar.gz
(3.2 kB
view hashes)
Built Distribution
Close
Hashes for pandaserd-0.1.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f799ca30bb59a90573c063ddabf190a5bd777336bf1613983cea2ab58fb78900 |
|
MD5 | c45d7ed293ef18ec429fb26d6f9d4dd7 |
|
BLAKE2b-256 | 8e21eb4ade35ebdeff8359a291bff4bd4743cbcbf000c4b1d9f6f6fafc5af092 |