read_table(self, table_name: 'str', index_col: 'str | Sequence[str] | None' = None, coerce_float: 'bool' = True, parse_dates=None, columns=None, schema: 'str | None' = None, chunksize: 'int | None' = None)
Name of SQL table in database.
Column to set as index.
Attempts to convert values of non-string, non-numeric objects (like decimal.Decimal) to floating point. This can result in loss of precision.
List of column names to parse as dates.
Dict of {column_name: format string}
where format string is strftime compatible in case of parsing string times, or is one of (D, s, ns, ms, us) in case of parsing integer timestamps.
Dict of {column_name: arg}
, where the arg corresponds to the keyword arguments of pandas.to_datetime
. Especially useful with databases without native Datetime support, such as SQLite.
List of column names to select from SQL table.
Name of SQL schema in database to query (if database flavor supports this). If specified, this overwrites the default schema of the SQL database object.
If specified, return an iterator where :None:None:`chunksize` is the number of rows to include in each chunk.
Read SQL database table into a DataFrame.
Hover to see nodes names; edges to Self not shown, Caped at 50 nodes.
Using a canvas is more power efficient and can get hundred of nodes ; but does not allow hyperlinks; , arrows or text (beyond on hover)
SVG is more flexible but power hungry; and does not scale well to 50 + nodes.
All aboves nodes referred to, (or are referred from) current nodes; Edges from Self to other have been omitted (or all nodes would be connected to the central node "self" which is not useful). Nodes are colored by the library they belong to, and scaled with the number of references pointing them