목록분류 전체보기 (832)

달나라 노트

Python Basic : filter()

python filter 함수는 list에서 원하는 데이터만을 filtering할 수 있도록 해줍니다. 바로 예시를 보시죠. list_test = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10] def filter_condition(x): if x >= 5: return x else: pass list_test_new = list(filter(filter_condition, list_test)) print(list_test_new) - Output [5, 6, 7, 8, 9, 10] 위 코드는 1부터 10까지의 저어수를 가진 list에서 5 이상인 정수만을 골라서 list로 만드는 코드입니다. def filter_condition(x) -> 먼저 filter method에서 filtering을 ..
Python/Python Basic 2020. 12. 23. 00:58
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
Prev 1 ··· 185 186 187 188 189 190 191 ··· 208 Next