Skip to content

Instantly share code, notes, and snippets.

View iedmrc's full-sized avatar
💭
Working Smart

ibrahim ethem demirci iedmrc

💭
Working Smart
View GitHub Profile
@iedmrc
iedmrc / async.py
Last active August 21, 2020 08:38 — forked from phizaz/async.py
Python turn sync functions to async (and async to sync)
import functools
import asyncio
from concurrent.futures import ThreadPoolExecutor
def to_async(func):
"""Turns a sync function to async function using event loop"""
@functools.wraps(func)
async def run(*args, loop=None, executor=None, **kwargs):
if loop is None:
@iedmrc
iedmrc / connect_psycopg2_to_pandas.py
Created July 23, 2020 10:11 — forked from jakebrinkmann/connect_psycopg2_to_pandas.py
Read SQL query from psycopg2 into pandas dataframe
import pandas as pd
import pandas.io.sql as sqlio
import psycopg2
conn = psycopg2.connect("host='{}' port={} dbname='{}' user={} password={}".format(host, port, dbname, username, pwd))
sql = "select count(*) from table;"
dat = sqlio.read_sql_query(sql, conn)
conn = None