sosukeinu

# -*- coding: utf-8 -*-
"""
LICENSE: BSD (same as pandas)
example use of pandas with oracle mysql postgresql sqlite
    - updated 9/18/2012 with better column name handling; couple of bug fixes.
    - used ~20 times for various ETL jobs.  Mostly MySQL, but some Oracle. 

    to do:  
            save/restore index (how to check table existence? just do select count(*)?), 
            finish odbc, 

sosukeinu

#List unique values in a DataFrame column
pd.unique(df.column_name.ravel())

#Convert Series datatype to numeric, getting rid of any non-numeric values
df['col'] = df['col'].astype(str).convert_objects(convert_numeric=True)

#Grab DataFrame rows where column has certain values
valuelist = ['value1', 'value2', 'value3']
df = df[df.column.isin(value_list)]

sosukeinu

CREATE OR REPLACE FUNCTION generate_object_id() RETURNS varchar AS $$
    DECLARE
        time_component bigint;
        machine_id int := FLOOR(random() * 16777215);
        process_id int;
        seq_id bigint := FLOOR(random() * 16777215);
        result varchar:= '';
    BEGIN
        SELECT FLOOR(EXTRACT(EPOCH FROM clock_timestamp())) INTO time_component;
        SELECT pg_backend_pid() INTO process_id;

sosukeinu

var boston_record = [
    ['home', 'win'],
    ...
    ['away', 'loss'],
];

d3.select('#second-wrapper-main')
  .selectAll('div')
    .data(boston_record)
  .enter().append('div')

sosukeinu

#!/usr/bin/env python                                           
                                                                
import apscheduler.scheduler                                    
import daemon.runner                                            
import os.path                                                  
import sys                                                      
import time                                                     
                                                                
class Core():                                                   
    def __init__(self):                                         

sosukeinu

What is this?

Python proof-of-concept implementation of two geomapping algorithms

Requirements

This code use the following packages:

sosukeinu

# -*- coding: utf-8 -*-
"""Example Google style docstrings.

This module demonstrates documentation as specified by the `Google Python
Style Guide`_. Docstrings may extend over multiple lines. Sections are created
with a section header and a colon followed by a block of indented text.

Example:
    Examples can be given using either the ``Example`` or ``Examples``
    sections. Sections support any reStructuredText formatting, including

sosukeinu

HOWTO: Create Your Own Self-Signed Certificate with Subject Alternative Names Using OpenSSL in Ubuntu Bash for Window

Overview

My main development workstation is a Windows 10 machine, so we'll approach this from that viewpoint.

Recently, Google Chrome started giving me a warning when I open a site that uses https and self-signed certificate on my local development machine due to some SSL certificate issues like the one below:

sosukeinu

# pip install python-binance

from binance.client import Client
client = Client(api_key, api_secret)

DUST = 0.001 # BTC

account = client.get_account()
prices  = client.get_all_tickers()

sosukeinu

"""
@debounce(3)
def hi(name):
    print('hi {}'.format(name))


hi('dude')
time.sleep(1)
hi('mike')
time.sleep(1)