Static Methods

Summary

staticmethod

class parent

truncated documentation

PYTHON

MagicFile

Defines command %%PYTHON.

PYTHON_parser

MagicFile

Defines the way to parse the magic command %%PYTHON.

SQL

MagicSQL

defines command %%SQL

SQL_add_function

MagicSQL

defines %SQL_add_function which adds a function to the database

SQL_add_function_parser

MagicSQL

defines the way to parse the magic command %SQL_add_function

SQL_close

MagicSQL

define SQL_close which closes a database

SQL_close_parser

MagicSQL

defines the way to parse the magic command %SQL_close

SQL_connect

MagicSQL

define SQL_connect which connects to a SQL database, it stores the database object in variable DB by default …

SQL_connect_parser

MagicSQL

defines the way to parse the magic command %SQL_connect

SQL_drop_table

MagicSQL

defines %SQL_drop_table which drops a table from a database

SQL_drop_table_parser

MagicSQL

defines the way to parse the magic command %SQL_drop_table

SQL_import_df

MagicSQL

defines %SQL_import_df which imports a dataframe into a database

SQL_import_df_parser

MagicSQL

defines the way to parse the magic command %SQL_import_df

SQL_import_tsv

MagicSQL

defines %SQL_import_tsv whichs import a TSV file into a database

SQL_import_tsv_parser

MagicSQL

defines the way to parse the magic command %SQL_import_tsv

SQL_parser

MagicSQL

defines the way to parse the magic command %%SQL

SQL_refresh_completion

MagicSQL

defines %SQL_refresh_completion

SQL_refresh_completion_parser

MagicSQL

defines the way to parse the magic command %SQL_refresh_completion

SQL_schema

MagicSQL

define SQL_schema

SQL_schema_parser

MagicSQL

defines the way to parse the magic command %SQL_schema

SQL_tables

MagicSQL

define %SQL_tables whichs lists the tables in a database

SQL_tables_parser

MagicSQL

defines the way to parse the magic command %SQL_tables

_filter_name

AutoCompletionSQLObject

removes unavailable characters

_special_function_init_

DatabaseCore

_store

TextFileColumns

Stores a list of dictionaries into a file (add a header).

available_dates

StockPrices

Returns the list of values (Open or High or Low or Close or Volume) from each stock for all the available_dates …

covariance

StockPrices

Computes the covariances matrix (of returns).

create

InterfaceSQL

draw

StockPrices

Draws a graph showing one or several time series. The example was taken date_demo.py. …

encoding

MagicFile

Defines %encoding which guesses the encoding.

encoding_parser

MagicFile

Defines the way to parse the magic command %encoding.

fill_sql_table

Database

Returns a Database object, creates the database if it does not exists, same for the table.

fusion

TextFileColumns

Does a fusion between several files with the same columns (different order is allowed).

getIndentationCount

Python3Lexer

grep

MagicFile

defines %grep which displays the first lines of a file

grep_parser

MagicFile

defines the way to parse the magic command %grep

head

MagicFile

Defines %head which displays the first lines of a file.

head_parser

MagicFile

defines the way to parse the magic command %head

hhelp

MagicFile

Define %hhelp, it displays the help for an object in :epkg:`HTML`.

hhelp_parser

MagicFile

Defines the way to parse the magic command %hhelp.

idaytodate

DatabaseCore

Date conversion. Static method to insert in a SQL query.

isectoday

DatabaseCore

Date conversion. Static method to insert in a SQL query.

itimestamp

DatabaseCore

Date conversion. Static method to insert in a SQL query.

jsdf

MagicNotebook

defines %jsdf which displays a pandas dataframe into a notebook using qgrid (javascript)

jsdf_parser

MagicNotebook

defines the way to parse the magic command %jsdf

lsr

MagicFile

Defines %lsr which returns the content of a folder, the method stops after around 10000 files –> you …

lsr_parser

MagicFile

defines the way to parse the magic command %lsr

lsrepo

MagicFile

Defines %lsrepo.

lsrepo_parser

MagicFile

Defines the way to parse the magic command %lsrepo.

mpl_style

MagicGraph

defines %mpl_style which changes the style of matplotlib graphs, example: %mpl_style ggplot

mpl_style_parser

MagicGraph

defines the way to parse the magic command %mpl_style

nb_menu

MagicNotebook

defines %nb_menu which displays a menu

nb_menu_parser

MagicNotebook

defines the way to parse the magic command %nb_menu

regex_match

DatabaseCore

Applies a regular expression. Static method to insert in a SQL query.

runpy

MagicFile

Defines command %%runpy.

runpy_parser

MagicFile

Defines the way to parse the magic command %%runpy.

schema_database

Database

Returns the schema for a database which would contains this database.

string_to_date

DatabaseCore

Date conversion. Static method to insert in a SQL query.

tail

MagicFile

defines %tail which displays the last lines of a file

tail_parser

MagicFile

defines the way to parse the magic command %tail