목록분류 전체보기 (847)

달나라 노트

Python Hive : access hive and run query using python

from pyhive import hive def query_execute_hive(query, result_cols): hive_connection = hive.Connection( host='host_name_url', port=10000 # port_number, username='hive_user_id', password='hive_user_password', database='default', auth='LDAP' ) cursor = hive_connection.cursor() raw_query_list = query.split(';\n') raw_query_list = [str(x).strip() for x in raw_query_list] raw_query_list = list(filter(..
Python/Python ETC 2020. 12. 23. 00:43
Python psycopg2 : access redshift and run query using python, python으로 redshift에서 쿼리 돌리기

import psycopg2 import pandas as pd def query_runner(query): dbname = 'sandbox' host = 'test_host' port = 1111 # port_number user_id = 'redshift_user_id' password = 'redshift_user_name' connection_info = "dbname='{}' host='{}' port={} user='{}' password='{}'".format(dbname, host, port, user_id, password) connection = psycopg2.connect(connection_info) cursor = connection.cursor() cursor.execute(q..
Python/Python ETC 2020. 12. 23. 00:20
Python webbrowser : open url on web browser

webbrowser library makes it possible for us to open url on your browser. import webbrowser url = 'https://www.google.com' webbrowser.open(url, new=1) The above code will open google in your base web browser. new = 0 -> open url in the same browser window. new = 1 -> open url in a new browser window. new = 2 -> open url in a new browser tab.
Python/Python webbrowser 2020. 12. 22. 23:34
Python googletrans

Python에선 googletrans라는 번역 기능을 가진 library를 제공합니다. googletrans 설치 pip install googletrans==4.0.0-rc1 일반적인 설치법으로 pip install googletrans를 하게되면 가끔 AttributeError: 'NoneType' object has no attribute 'group' 위와 같은 에러가 지속적으로 뜨는 경우가 있습니다. 이럴 경우에는 위 커맨드로 해당 버전을 설치해줍시다. (참고 : github.com/ssut/py-googletrans/issues/234) from googletrans import Translator translator = Translator() translated_obj = translator..
Python/Python googletrans 2020. 12. 21. 18:34
Prev 1 ··· 189 190 191 192 193 194 195 ··· 212 Next