00krishna
/ pandas.postgres.py
Last active
March 21, 2022 13:44
Connect from python pandas to a postgresql database and pull data.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import psycopg2 as pg | |
| import pandas.io.sql as psql | |
| # get connected to the database | |
| connection = pg.connect("dbname=mydatabase user=postgres") | |
| dataframe = psql.frame_query("SELECT * FROM <tablename>", connection) |
pmarshwx
/ epanechnikov.pyx
Last active
November 11, 2018 10:45
Epanechnikov kernel for use in Kernel Density Estimation. Note, for large arrays, performance may be slow. Originally designed for sparse grids.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| cimport cython | |
| import numpy as np | |
| cimport numpy as np | |
| cdef extern from 'math.h': | |
| float exp(float x) | |
| float cos(float x) | |
| float sin(float x) | |
| float fabs(float x) |