<Google Cloud Platform> Google Cloud Shell
Google Cloud Platformのdashboardを見てた時、、
https://console.cloud.google.com/home/dashboard
ふと、、
Google Cloud Shellというボタンがあった。
押してみた。
画面下に、コンソール画面が現れた。
tmuxもあるよ、、とかも書いてあった。
なんだろ、、、ふつーにLinuxっぽいし、、って思っていたら、
どうも、ここで、app作ってdeployできるっぽい。
ローカル要らない！ ほー。へー。
<Google Cloud Platform, Flask> Flaskを動かしてみる。
Flaskさんを動かしてみる。
こちらを参考。
Gitして、dev_appserver.pyしてみた。
py27 % git clone https://github.com/GoogleCloudPlatform/appengine-flask-skeleton.git Cloning into 'appengine-flask-skeleton'... remote: Counting objects: 520, done. remote: Total 520 (delta 0), reused 0 (delta 0), pack-reused 520 Receiving objects: 100% (520/520), 1.15 MiB | 333.00 KiB/s, done. Resolving deltas: 100% (64/64), done. py27 % cd appengine-flask-skeleton/ app.yaml appengine_config.py CONTRIB.md lib/ LICENSE main.py README.md requirements.txt py27 % ls lib flask/ itsdangerous.py jinja2/ markupsafe/ README.md Werkzeug-0.11.dist-info/ Flask-0.10.dist-info/ itsdangerous-0.24.dist-info/ Jinja2-2.8.dist-info/ MarkupSafe-0.23.dist-info/ werkzeug/ py27 % ~/google-cloud-sdk/bin/dev_appserver.py . INFO 2016-11-19 11:49:12,184 devappserver2.py:769] Skipping SDK update check. WARNING 2016-11-19 11:49:12,286 simple_search_stub.py:1146] Could not read search indexes from c:\users\nekoyuki\appdata\local\temp\appengine.None\search_indexes INFO 2016-11-19 11:49:12,296 api_server.py:205] Starting API server at: http://localhost:55930 INFO 2016-11-19 11:49:12,302 dispatcher.py:197] Starting module "default" running at: http://localhost:8080 INFO 2016-11-19 11:49:12,303 admin_server.py:116] Starting admin server at: http://localhost:8000 INFO 2016-11-19 11:49:49,451 module.py:788] default: "GET / HTTP/1.1" 200 13 INFO 2016-11-19 11:49:50,355 module.py:788] default: "GET /favicon.ico HTTP/1.1" 404 154
localhost:8080でHello World!を確認。
動いたっぽい。なるへそ。
その後、、、
デプロイdeployしてみた。
まずは、こちらで、プロジェクト作成。
https://console.cloud.google.com/home/dashboard
で、
こちらのクイックスタートquickstartに従う。
https://cloud.google.com/appengine/docs/python/quickstart
py27 % ~/google-cloud-sdk/bin/gcloud app deploy --project hagehage-xxxxxx which: no python2 in (/C/Anaconda3/envs/py27:/C/Anaconda3/envs/py27/Library/mingw-w64/bin:/C/Anaconda3/envs/py27/Library/usr/bin:/C/Anaconda3/envs/py27/Library/bin:/C/Anaconda3/en:/home/Nekoyuki/.zplug/bin:/c/\Program Files (x86)/Google/Chrome/Application:/c/Go/bin:/c/Anaconda3:/c/Anaconda3/Scripts:/usr/local/bin:/usr/bin:/bin:/opt/bin:/c/Windows/System32:/c/Windows:/c/Windows/System32/Wbem:/c/Windows/System32/WindowsPowerShell/v1.0/:/usr/bin/site_perl:/usr/bin/vendor_perl:/usr/bin/core_perl) which: no python2.7 in (/C/Anaconda3/envs/py27:/C/Anaconda3/envs/py27/Library/mingw-w64/bin:/C/Anaconda3/envs/py27/Library/usr/bin:/C/Anaconda3/envs/py27/Library/bin:/C/Anaconda3/:/home/Nekoyuki/.zplug/bin:/c/\Program Files (x86)/Google/Chrome/Application:/c/Go/bin:/c/Anaconda3:/c/Anaconda3/Scripts:/usr/local/bin:/usr/bin:/bin:/opt/bin:/c/Windows/System32:/c/Windows:/c/Windows/System32/Wbem:/c/Windows/System32/WindowsPowerShell/v1.0/:/usr/bin/site_perl:/usr/bin/vendor_perl:/usr/bin/core_perl) WARNING: Automatic app detection is currently in Beta You are about to deploy the following services: - hagehage-xxxxxx/default/20161119t223810 (from [C:\msys64\home\Nekoyuki\works\works_google_cloud_platform\appengine-flask-skeleton\app.yaml]) Deployed URL: [https://hagehage-xxxxxx.appspot.com] Do you want to continue (Y/n)? Beginning deployment of service [default]... : いろいろエラーやらワーニングやら、、、 : File upload done. Updating service [default]... Updating service [default]...done. Deployed service [default] You can read logs from the command line by running: $ gcloud app logs read To view your application in the web browser run: $ gcloud app browse
お？いけた？
で、下記にアクセス。
https://hagehage-xxxxxx.appspot.com/
おおー！ Hello World!が見れた。
メモ。
Google Cloud関係のgithubは下記らしい。
こちらも参考。
<Google Cloud Platform> ごっちゃかも、、
msys2にGoogle Cloud SDKを入れたんだが、
gcloud initの挙動が下記と異なる。
なんとなく、、、
最初にWindows版を入れたのが足を引っ張ってるっぽい。
configが、~/.configでなくて、
% cd google-cloud-sdk/ bin/ help/ lib/ path.zsh.inc README completion.bash.inc install.bat LICENSE platform/ RELEASE_NOTES completion.zsh.inc install.sh* path.bash.inc properties % cd bin bootstrapping/ gcloud* git-credential-gcloud.cmd sdk/ bq* gcloud.cmd git-credential-gcloud.sh* dev_appserver.py* gcloud-ps.ps1 gsutil* % source activate py27 py27 % ./gcloud info which: no python2 in (/C/Anaconda3/envs/py27:/C/Anaconda3/envs/py27/Library/mingw-w64/bin:/C/Anaconda3/envs/py27/Library/usr/bin:/C/Anaconda3/envs/py27/Library/bin:/C/Anaco:/home/Nekoyuki/.zplug/bin:/c/\Program Files (x86)/Google/Chrome/Application:/c/Go/bin:/c/Anaconda3:/c/Anaconda3/Scripts:/usr/local/bin:/usr/bin:/bin:/opt/bin:/c/Windows/System32:/c/Windows:/c/Windows/System32/Wbem:/c/Windows/System32/WindowsPowerShell/v1.0/:/usr/bin/site_perl:/usr/bin/vendor_perl:/usr/bin/core_perl) which: no python2.7 in (/C/Anaconda3/envs/py27:/C/Anaconda3/envs/py27/Library/mingw-w64/bin:/C/Anaconda3/envs/py27/Library/usr/bin:/C/Anaconda3/envs/py27/Library/bin:/C/Ana:/home/Nekoyuki/.zplug/bin:/c/\Program Files (x86)/Google/Chrome/Application:/c/Go/bin:/c/Anaconda3:/c/Anaconda3/Scripts:/usr/local/bin:/usr/bin:/bin:/opt/bin:/c/Windows/System32:/c/Windows:/c/Windows/System32/Wbem:/c/Windows/System32/WindowsPowerShell/v1.0/:/usr/bin/site_perl:/usr/bin/vendor_perl:/usr/bin/core_perl) Google Cloud SDK [121.0.0] Platform: [Windows, x86_64] Python Version: [2.7.12 |Continuum Analytics, Inc.| (default, Jun 29 2016, 11:07:13) [MSC v.1500 64 bit (AMD64)]] Python Location: [C:\Anaconda3\envs\py27\python.exe] Site Packages: [Disabled] Installation Root: [C:\msys64\home\Nekoyuki\google-cloud-sdk] Installed Components: core: [2016.08.05] app-engine-python: [1.9.38] core-nix: [2016.08.05] core-win: [2016.08.05] gcloud: [] windows-ssh-tools: [2016.05.13] gsutil-nix: [4.20] gsutil: [4.20] bq: [2.0.24] bq-nix: [2.0.24] System PATH: [C:\Anaconda3\envs\py27;C:\Anaconda3\envs\py27\Library\mingw-w64\bin;C:\Anaconda3\envs\py27\Library\usr\bin;C:\Anaconda3\envs\py27\Library\bin;C:\Anaconda3\env;C:\msys64\home\Nekoyuki\.zplug\bin;C:\Program Files (x86)\Google\Chrome\Application;C:\Go\bin;C:\Anaconda3;C:\Anaconda3\Scripts;C:\msys64\usr\local\bin;C:\msys64\usr\bin;C:\msys64\usr\bin;C:\msys64\opt\bin;C:\Windows\System32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\msys64\usr\bin\site_perl;C:\msys64\usr\bin\vendor_perl;C:\msys64\usr\bin\core_perl] Cloud SDK on PATH: [False] Installation Properties: [C:\msys64\home\Nekoyuki\google-cloud-sdk\properties] User Config Directory: [C:\Users\Nekoyuki\AppData\Roaming\gcloud] Active Configuration Name: [default] Active Configuration Path: [C:\Users\Nekoyuki\AppData\Roaming\gcloud\configurations\config_default] Account: [hagehage@gmail.com] Project: [None] Current Properties: [core] account: [hagehage@gmail.com] disable_usage_reporting: [False] Logs Directory: [C:\Users\Nekoyuki\AppData\Roaming\gcloud\logs] Last Log File: [C:\Users\Nekoyuki\AppData\Roaming\gcloud\logs\2016.11.19\11.36.28.968000.log]
となって、AppData\Roamingの下にある。。。
なんとなく、ぐっちゃになってしまったのかも。。。
ただ、動いているから、いいかな、、、
msys2上の方が使いやすいし。
<msys2, Google Cloud Platform> Linux版をいれてみた。
Google app engineだが、どうもWindows版はよくわからない。
msys2があるので、Linux版をいれてみた。
まずは、ここからtarボールを落とす。
https://cloud.google.com/sdk/docs/#linux
で、condaさんで、python2.7化しておく。
py27 % gunzip google-cloud-sdk-121.0.0-linux-x86_64.tar.gz py27 % tar xvf google-cloud-sdk-121.0.0-linux-x86_64.tar py27 % cd google-cloud-sdk/ bin/ completion.zsh.inc install.bat lib/ path.bash.inc platform/ README completion.bash.inc help/ install.sh* LICENSE path.zsh.inc properties RELEASE_NOTES py27 % ./install.sh Welcome to the Google Cloud SDK! Do you want to help improve the Google Cloud SDK (Y/n)? Your current Cloud SDK version is: 121.0.0 The latest available version is: 135.0.0 To help improve the quality of this product, we collect anonymized data on how the SDK is used. You may choose to opt out of this collection now (by choosing 'N' at the below prompt), or at any time in the future by running the following command: gcloud config set disable_usage_reporting true +----------------------------------------------------------------------------------------------------------------+ | Components | +------------------+------------------------------------------------------+--------------------------+-----------+ | Status | Name | ID | Size | +------------------+------------------------------------------------------+--------------------------+-----------+ | Update Available | BigQuery Command Line Tool | bq | < 1 MiB | | Update Available | Cloud SDK Core Libraries | core | 5.1 MiB | | Update Available | Cloud Storage Command Line Tool | gsutil | 2.8 MiB | | Not Installed | App Engine Go Extensions | app-engine-go | 47.8 MiB | | Not Installed | Cloud Datastore Emulator | cloud-datastore-emulator | 15.4 MiB | | Not Installed | Cloud Datastore Emulator (Legacy) | gcd-emulator | 38.1 MiB | | Not Installed | Cloud Pub/Sub Emulator | pubsub-emulator | 16.3 MiB | | Not Installed | Google Container Registry's Docker credential helper | docker-credential-gcr | 2.1 MiB | | Not Installed | gcloud Alpha Commands | alpha | < 1 MiB | | Not Installed | gcloud Beta Commands | beta | < 1 MiB | | Not Installed | gcloud app Java Extensions | app-engine-java | 124.4 MiB | | Not Installed | gcloud app PHP Extensions (Windows) | app-engine-php-windows | 19.1 MiB | | Not Installed | gcloud app Python Extensions | app-engine-python | 7.2 MiB | | Not Installed | kubectl | kubectl | 16.0 MiB | | Installed | Default set of gcloud commands | gcloud | | +------------------+------------------------------------------------------+--------------------------+-----------+ To install or remove components at your current SDK version [121.0.0], run: $ gcloud components install COMPONENT_ID $ gcloud components remove COMPONENT_ID To update your SDK installation to the latest version [135.0.0], run: $ gcloud components update Update %PATH% to include Cloud SDK binaries? (Y/n)? The installer is unable to automatically update your system PATH. Please add C:\msys64\home\Nekoyuki\google-cloud-sdk\bin to your system PATH to enable easy use of the Cloud SDK Command Line Tools. For more information on how to get started, please visit: https://cloud.google.com/sdk/#Getting_Started
ふーん、、、
Not Installedの項目がいくつかあるが、まあいいか、、、次をやる。
gcloud initをしろとあるので、やってみる。
py27 % ls bin/ completion.zsh.inc install.bat lib/ path.bash.inc platform/ README completion.bash.inc help/ install.sh* LICENSE path.zsh.inc properties RELEASE_NOTES py27 % cd bin/ bootstrapping/ bq* dev_appserver.py* gcloud* git-credential-gcloud.sh* gsutil* py27 % ./gcloud init which: no python2 in (/C/Anaconda3/envs/py27:/C/Anaconda3/envs/py27/Library/mingw-w64/bin:/C/Anaconda3/envs/py27/Library/u:/home/Nekoyuki/.zplug/bin:/c/\Program Files (x86)/Google/Chrome/Application:/c/Go/bin:/c/Anaconda3:/c/Anaconda3/Scripts:/usr/local/bin:/usr/bin:/bin:/opt/bin:/c/Windows/System32:/c/Windows:/c/Windows/System32/Wbem:/c/Windows/System32/WindowsPowerShell/v1.0/:/usr/bin/site_perl:/usr/bin/vendor_perl:/usr/bin/core_perl) which: no python2.7 in (/C/Anaconda3/envs/py27:/C/Anaconda3/envs/py27/Library/mingw-w64/bin:/C/Anaconda3/envs/py27/Library:/home/Nekoyuki/.zplug/bin:/c/\Program Files (x86)/Google/Chrome/Application:/c/Go/bin:/c/Anaconda3:/c/Anaconda3/Scripts:/usr/local/bin:/usr/bin:/bin:/opt/bin:/c/Windows/System32:/c/Windows:/c/Windows/System32/Wbem:/c/Windows/System32/WindowsPowerShell/v1.0/:/usr/bin/site_perl:/usr/bin/vendor_perl:/usr/bin/core_perl) Welcome! This command will take you through the configuration of gcloud. Settings from your current configuration [default] are: [core] account = hagehage@gmail.com disable_usage_reporting = False Your active configuration is: [default]
なんか、コマンド待ちの状態で終わるので、Ctrl+Cで切る。
ちと、中を見てみたけど、よくわからないので、次をやってみる。
これ。quickstart
https://cloud.google.com/appengine/docs/python/quickstart
これに従いgitとして、dev_appserver.pyしたら次となった。
py27 % ~/google-cloud-sdk/bin/dev_appserver.py This action requires the installation of components: [app-engine- python] Your current Cloud SDK version is: 121.0.0 Installing components from version: 121.0.0 +---------------------------------------------------------------------+ | These components will be installed. | +----------------------------------------------+------------+---------+ | Name | Version | Size | +----------------------------------------------+------------+---------+ | Cloud SDK Core Libraries (Platform Specific) | 2016.08.05 | < 1 MiB | | Windows command line ssh tools | 2016.05.13 | 1.8 MiB | | gcloud app Python Extensions | 1.9.38 | 7.2 MiB | +----------------------------------------------+------------+---------+ For the latest full release notes, please visit: https://cloud.google.com/sdk/release_notes Do you want to continue (Y/n)? #============================================================# #= Creating update staging area =# #============================================================# #= Installing: Cloud SDK Core Libraries (Platform Specific) =# #============================================================# #= Installing: Windows command line ssh tools =# #============================================================# #= Installing: gcloud app Python Extensions =# #============================================================# #= Creating backup and activating new installation =# #============================================================# Performing post processing steps... Performing post processing steps...done. Update done! Restarting command: $ dev_appserver.py usage: dev_appserver.py [-h] [-A APP_ID] [--host HOST] [--port PORT] [--admin_host ADMIN_HOST] [--admin_port ADMIN_PORT] [--auth_domain AUTH_DOMAIN] [--storage_path PATH] [--log_level {debug,info,warning,critical,error}] [--max_module_instances MAX_MODULE_INSTANCES] [--use_mtime_file_watcher [USE_MTIME_FILE_WATCHER]] [--threadsafe_override THREADSAFE_OVERRIDE] [--php_executable_path PATH] [--php_remote_debugging [PHP_REMOTE_DEBUGGING]] [--php_gae_extension_path PATH] [--php_xdebug_extension_path PATH] [--appidentity_email_address APPIDENTITY_EMAIL_ADDRESS] [--appidentity_private_key_path APPIDENTITY_PRIVATE_KEY_PATH] [--python_startup_script PYTHON_STARTUP_SCRIPT] [--python_startup_args PYTHON_STARTUP_ARGS] [--jvm_flag JVM_FLAG] [--custom_entrypoint CUSTOM_ENTRYPOINT] [--runtime RUNTIME] [--blobstore_path BLOBSTORE_PATH] [--mysql_host MYSQL_HOST] [--mysql_port MYSQL_PORT] [--mysql_user MYSQL_USER] [--mysql_password MYSQL_PASSWORD] [--mysql_socket MYSQL_SOCKET] [--datastore_path DATASTORE_PATH] [--clear_datastore [CLEAR_DATASTORE]] [--datastore_consistency_policy {consistent,random,time}] [--require_indexes [REQUIRE_INDEXES]] [--auto_id_policy {sequential,scattered}] [--logs_path LOGS_PATH] [--show_mail_body [SHOW_MAIL_BODY]] [--enable_sendmail [ENABLE_SENDMAIL]] [--smtp_host SMTP_HOST] [--smtp_port SMTP_PORT] [--smtp_user SMTP_USER] [--smtp_password SMTP_PASSWORD] [--smtp_allow_tls [SMTP_ALLOW_TLS]] [--prospective_search_path PROSPECTIVE_SEARCH_PATH] [--clear_prospective_search [CLEAR_PROSPECTIVE_SEARCH]] [--search_indexes_path SEARCH_INDEXES_PATH] [--clear_search_indexes [CLEAR_SEARCH_INDEXES]] [--enable_task_running [ENABLE_TASK_RUNNING]] [--allow_skipped_files [ALLOW_SKIPPED_FILES]] [--api_port API_PORT] [--automatic_restart [AUTOMATIC_RESTART]] [--dev_appserver_log_level {debug,info,warning,critical,error}] [--skip_sdk_update_check [SKIP_SDK_UPDATE_CHECK]] [--default_gcs_bucket_name DEFAULT_GCS_BUCKET_NAME] yaml_path [yaml_path ...] dev_appserver.py: error: too few arguments
なるへそ。
Not Installの項目がインストールされた。
つうことで、再度、
py27 % ~/google-cloud-sdk/bin/dev_appserver.py .
して、ブラウザで、http://localhost:8080/アクセスしたら、Hello, World!がちゃんとでた。
おっけーかな？
<Google Cloud Platform> インストール。
ずっと入れようか悩んでいたけど、入れた三田。
まずは、pythonのページへ行く。
で、そこから
クイックスタート クリック、
スタンダード環境ではじめる クリック、
DOWNLOAD THE SDK クリック、
Cloud SDK installer クリック、
で、SDK installerをダウンロードしてインストール。
Google Cloud SDK Documentation | Cloud SDK | Google Cloud Platform
python2.7がない場合、バンドル版をチェック。
Anacondaがあるが、まあ、深く考えず、デフォルト(バンドル版がチェック)で進める。
インストールが完了すると、
何も考えずにデフォルトで進めると、
ターミナルが立ち上がり、
そのままYesで進めると、
ブラウザが立ち上がり、
Googleのアカウントでログインすると、
Google Cloud SDK の認証が完了しましたとなった。
うまくいったのかな？？？
gcolud
gcloud Overview | Cloud SDK Documentation | Google Cloud Platform
こちらを参考。
<Python, pandas> 行(row)を追加する。
行rowを追加する。行の追加。
こういうデータフレームDataFrameがあった時、
In [71]: df Out[71]: id name birthday is_relative 0 1 Hage 1960-01-01 1 1 2 Hige 1960-01-02 1
１行追加したい時は、シリーズSeriesでデータ作って、.append()すればいいっぽい。
やってみた。
In [74]: se = pd.Series([3, 'Hoge', date(1960,1,3), 1], index=df.columns) In [75]: se Out[75]: id 3 name Hoge birthday 1960-01-03 is_relative 1 dtype: object In [76]: df.append(se, ignore_index=True) Out[76]: id name birthday is_relative 0 1 Hage 1960-01-01 1 1 2 Hige 1960-01-02 1 2 3 Hoge 1960-01-03 1
にゃるほど。
18/09/03 追加
他のナイスなやり方を学んだの追加するっち。
DataFrame.locを使うなり。
loc[hoge]でhoge行を選択できるので、そこに値のリストを流し込めば、おっけー！ ひゃっほう！
In [33]: import pandas as pd In [34]: import io In [35]: data = ''' ...: a b c d e ...: 1 2 3 4 5 ...: 6 7 8 9 10 ...: ''' In [36]: df = pd.read_table(io.StringIO(data), sep=' ') In [37]: df Out[37]: a b c d e 0 1 2 3 4 5 1 6 7 8 9 10 In [38]: df.loc[0] Out[38]: a 1 b 2 c 3 d 4 e 5 Name: 0, dtype: int64 In [40]: df.loc[3] = [i for i in range(100,105)] In [41]: df Out[41]: a b c d e 0 1 2 3 4 5 1 6 7 8 9 10 3 100 101 102 103 104
<Pandas, peewee, sqlite> peeweeを少しためす。
peeweeを少しためしてみた。
まずは、データベースdatabase作成とデータ登録。
In [51]: from peewee import * In [52]: db = SqliteDatabase('people.db') In [53]: class Person(Model): ...: name = CharField() ...: birthday = DateField() ...: is_relative = BooleanField() ...: class Meta: ...: database = db ...: In [54]: db.connect() In [55]: db.create_tables([Person]) In [57]: from datetime import date In [58]: hage = Person(name='Hage', birthday=date(1960,1,1), is_relative=True) In [59]: hage.save() Out[59]: 1 In [60]: hige = Person(name='Hige', birthday=date(1960,1,2), is_relative=True) In [61]: hige.save() Out[61]: 1
で、次に登録したデータの読出し。
In [62]: Person.select() Out[62]: <class '__main__.Person'> SELECT "t1"."id", "t1"."name", "t1"."birthday", "t1"."is_relative" FROM "person" AS t1 [] In [63]: for p in Person.select(): ...: print(p.name, p.birthday, p.is_relative) ...: Hage 1960-01-01 True Hige 1960-01-02 True
データベースの場合、pandasさんで読みだすと楽なので、ためす。
In [64]: import pandas as pd In [65]: pd.io.sql.read_sql('SELECT * FROM Person', db) --------------------------------------------------------------------------- AttributeError Traceback (most recent call last) <ipython-input-65-bdc8325f4385> in <module>() ----> 1 pd.io.sql.read_sql('SELECT * FROM Person', db) C:\Anaconda3\Lib\site-packages\pandas\io\sql.py in read_sql(sql, con, index_col, coerce_float, params, parse_dates, columns, chunksize) 497 sql, index_col=index_col, params=params, 498 coerce_float=coerce_float, parse_dates=parse_dates, --> 499 chunksize=chunksize) 500 501 try: C:\Anaconda3\Lib\site-packages\pandas\io\sql.py in read_query(self, sql, index_col, coerce_float, params, parse_dates, chunksize) 1593 1594 args = _convert_params(sql, params) -> 1595 cursor = self.execute(*args) 1596 columns = [col_desc[0] for col_desc in cursor.description] 1597 C:\Anaconda3\Lib\site-packages\pandas\io\sql.py in execute(self, *args, **kwargs) 1553 cur = self.con 1554 else: -> 1555 cur = self.con.cursor() 1556 try: 1557 if kwargs: AttributeError: 'SqliteDatabase' object has no attribute 'cursor'
エラー。
どうもpeeweeのコネクションでは動かないらしい。
しょうがないので、sqlite3モジュールをコール。
In [66]: import sqlite3 In [67]: con = sqlite3.connect('people.db') In [68]: pd.io.sql.read_sql('SELECT * FROM Person', con) Out[68]: id name birthday is_relative 0 1 Hage 1960-01-01 1 1 2 Hige 1960-01-02 1
こちらにお世話になった。
あとマニュアル。
