목록Python (387)

달나라 노트

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
Python tableauserverclient : Refresh workbook

Tableau Server Client(TSC) Let us check how to refresh workbook. Filtering workbook using workbook name and refresh that workbook. # -------------------------------------------------- # Chapter 3. Tableau workbbok refresh # To refresh workbook you need workbook id of the workbook you want to refresh. # To get workbook id, you can use filter function in Chapter 2 # -------------------------------..
Python/Python tableauserverclient 2020. 12. 21. 16:28
Prev 1 ··· 82 83 84 85 86 87 88 ··· 97 Next