Magic commands about files

Links: notebook, html, PDF, python, slides, GitHub

Use of magic commands implemented by pyensae.

%load_ext pyensae
from pyensae.sql import Database

%lsr .*[.]ipynb
directory last_modified name size
0 False 2016-11-09 23:35:42.656229 .\azure_blob_storage.ipynb 33.91 Kb
1 False 2016-11-09 23:35:42.667238 .\example_corrplot.ipynb 203.16 Kb
2 False 2016-11-09 23:35:42.683248 .\example_of_ssh_client_communication.ipynb 199.06 Kb
3 False 2016-11-09 23:35:42.695257 .\folium_map.ipynb 17.60 Kb
4 False 2017-01-07 18:38:26.725089 .\magic_commands_about_files.ipynb 15.37 Kb
5 False 2016-12-28 23:04:00.646329 .\pyensae_flat2db3.ipynb 72.66 Kb
6 False 2016-12-28 23:04:00.681589 .\pyensae_sql_magic.ipynb 71.64 Kb
7 False 2016-11-09 23:35:42.728279 .\pyensae_StockPrices.ipynb 488.76 Kb
8 False 2016-12-28 23:04:00.747517 .\pyensae_text2table.ipynb 25.68 Kb
9 False 2016-11-09 23:35:42.770842 .\pyensae_velib.ipynb 300.54 Kb
10 False 2016-11-09 23:35:42.778852 .\python_hadoop_pig.ipynb 57.73 Kb
11 False 2016-11-09 23:35:42.784856 .\using_qgrid_with_jsdf.ipynb 6.71 Kb
12 False 2016-12-28 23:04:00.827547 .\view_differences.ipynb 49.39 Kb
13 False 2016-12-28 23:04:00.838553 .\.ipynb_checkpoints\magic_commands_about_file... 26.17 Kb
14 False 2016-12-28 23:04:00.915596 .\.ipynb_checkpoints\pyensae_flat2db3-checkpoi... 72.66 Kb
15 False 2016-12-28 23:04:00.931221 .\.ipynb_checkpoints\pyensae_sql_magic-checkpo... 71.64 Kb
16 False 2016-12-28 23:04:00.961358 .\.ipynb_checkpoints\pyensae_text2table-checkp... 25.68 Kb
17 False 2016-12-28 23:04:00.984509 .\.ipynb_checkpoints\view_differences-checkpoi... 49.39 Kb 
%head --help

usage: head [-h] [-n N] [-r] [-e ENCODING] [-s ERRORS] f
display the first lines of a text file
positional arguments:
  f                     filename
optional arguments:
  -h, --help            show this help message and exit
  -n N, --n N           number of lines to display
  -r, --raw             display raw text instead of HTML
  -e ENCODING, --encoding ENCODING
                        file encoding
  -s ERRORS, --errors ERRORS
                        What about errors: "", strict, replace,
                        surrogateescape, xmlcharrefreplace, backslashreplace,
                        namereplace
usage: head [-h] [-n N] [-r] [-e ENCODING] [-s ERRORS] f

%hhelp Database.__init__

constructor

param dbfile:
 

database file (use :memory: to avoid creating a file and using only memory) it can also contain several files separated by ;:

name_file ; nickname,second_file ; ...
param engine:
 

SQLite or MySQL (if it is installed)
param user:
 

user if needed
param password:
 

password if needed
param host:
 

to connect to a MSSQL database
param LOG:

LOG function
param attach:
 

dictionary: { nickname: filename }, list of database to attach

Warning

If the folder does not exist, it will be created

%hhelp -f text Database.__init__

constructor
@param      dbfile          database file (use :memory: to avoid creating a file and using only memory)
                            it can also contain several files separated by ;
                                @code
                                name_file ; nickname,second_file ; ...
                                @endcode
@param      engine          SQLite or MySQL (if it is installed)
@param      user            user if needed
@param      password        password if needed
@param      host            to connect to a MSSQL database
@param      LOG             LOG function
@param      attach          dictionary: { nickname: filename }, list of database to attach
@warning If the folder does not exist, it will be created
%encoding pyensae_sql_magic.ipynb

"{'confidence': 1.0, 'encoding': 'ascii'}"