0. 오픈 튜트리얼 wiki 사용법
--> 다시 확인.
1. Python
-- Python 3.6.1 32bit 설치
-- windwos 환경 변수 확인 %PYTHON_HOME%;%PYTHON_HOME\scripts;
-- pip3 설치 확인
!! 원래는 linux 에서는 python -> easy_install -> pip 설치. easy_install 은 deprecated.
2. pip 사용법
-- pip3 search oracle
-- pip3 search pandas
-- pip3 search pandas_datareader
-- pip3 install pandas
-- pip install wheel file
-- import pandas
D:\>pip list
DEPRECATION: The default format will switch to columns in the future. You can use --
f under the [list] section) to disable this warning.
pip (9.0.1)
setuptools (28.8.0)
D:\> pip3 list --format columns
Package Version
---------- -------
pip 9.0.1
setuptools 28.8.0
D:\>pip3 search pandas |more
D:\>pip3 install pandas
Collecting pandas
Downloading pandas-0.20.1-cp36-cp36m-win32.whl (7.5MB)
100% |████████████████████████████████| 7.5MB 107kB/s
Collecting pytz>=2011k (from pandas)
Using cached pytz-2017.2-py2.py3-none-any.whl
Collecting python-dateutil>=2 (from pandas)
Using cached python_dateutil-2.6.0-py2.py3-none-any.whl
Collecting numpy>=1.7.0 (from pandas)
Using cached numpy-1.12.1-cp36-none-win32.whl
Collecting six>=1.5 (from python-dateutil>=2->pandas)
Using cached six-1.10.0-py2.py3-none-any.whl
Installing collected packages: pytz, six, python-dateutil, numpy, pandas
Successfully installed numpy-1.12.1 pandas-0.20.1 python-dateutil-2.6.0 pytz-2017.2 six-1.10.0
D:\>
D:\>pip list --format columns
Package Version
--------------- -------
numpy 1.12.1
pandas 0.20.1
pip 9.0.1
python-dateutil 2.6.0
pytz 2017.2
setuptools 28.8.0
six 1.10.0
D:\>
4. MSSQL. 예제.
-- library 설치
D:\dev\workspace\Python>pip3 install pymssql
Collecting pymssql
-- Error
D:\dev\Python36-32\wheels>pip3 install pymssql-2.1.3-cp36-cp36m-win32.whl
Processing d:\dev\python36-32\wheels\pymssql-2.1.3-cp36-cp36m-win32.whl
Installing collected packages: pymssql
Successfully installed pymssql-2.1.3
D:\dev\Python36-32\wheels>
-- 예제 실행
D:\dev\workspace\Python>python dbConnMSSQL.py
Traceback (most recent call last):
File "pymssql.pyx", line 635, in pymssql.connect (pymssql.c:10734)
File "_mssql.pyx", line 1902, in _mssql.connect (_mssql.c:21821)
File "_mssql.pyx", line 637, in _mssql.MSSQLConnection.__init__ (_mssql.c:6581)
File "_mssql.pyx", line 1630, in _mssql.maybe_raise_MSSQLDatabaseException (_mssql.c:17524)
_mssql.MSSQLDatabaseException: (20009, b'DB-Lib error message 20009, severity 9:\nUnable to con
:53329)\nNet-Lib error during Unknown error (10060)\n')
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "dbConnMSSQL.py", line 3, in <module>
conn = pymssql.connect(host='localhost:53329', user='rohys03', password='qwer12', database=
File "pymssql.pyx", line 641, in pymssql.connect (pymssql.c:10824)
pymssql.OperationalError: (20009, b'DB-Lib error message 20009, severity 9:\nUnable to connect:
9)\nNet-Lib error during Unknown error (10060)\n')
D:\dev\workspace\Python>python dbConnMSSQL.py
Col1=26145, Col2=9609
Col1=26146, Col2=9553
Col1=26147, Col2=2493
Col1=26148, Col2=7318
Col1=26149, Col2=7883
Col1=26150, Col2=9835
Col1=26151, Col2=4965
Col1=26152, Col2=6612
Col1=26153, Col2=1364
Col1=26154, Col2=8686
Fetch End.
D:\dev\workspace\Python>
7. Atom 설치 패키지
1. script : atom run script
https://atom.io/packages/script
2. autocomplete-python : autocomplete statement
3. highlight
4. xml formatter
