autodatadictionary 0.0.5

Generate automated data dictionary from files and databases

DataDictionary

AutoDataDictionary generates data dictionary from source files and database tables including:

• Column Name
• Sample Value
• Source File Name
• Non Null Values Count
• Unique Values Count
• Data Type
• Unique Values List

How to use

Generate data dictionary from db

import autodatadictionary as ad
ad.to_dictionary_from_db(
     sql_alchemy_connection_string='postgresql://username:password@domain:5432/db',
     schema='schema')

Generate data dictionary from csv files

import autodatadictionary as ad
ad.to_dictionary_from_file(['/path/data1.csv', '/path/data2.csv', '/path/dataN.csv'], sep=',')