abubelinha

## df_to_markdown.py
import pandas as pd
from tabulate import tabulate

def pandas_df_to_markdown_table(df):
    # Dependent upon ipython
    # shamelessly stolen from https://stackoverflow.com/questions/33181846/programmatically-convert-pandas-dataframe-to-markdown-table
    from IPython.display import Markdown, display
    fmt = ['---' for i in range(len(df.columns))]
    df_fmt = pd.DataFrame([fmt], columns=df.columns)
    df_formatted = pd.concat([df_fmt, df])

## push_file_to_github_repo_branch.py
import requests
import base64
import json
import datetime


def push_to_repo_branch(gitHubFileName, fileName, repo_slug, branch, user, token):
    '''
    Push file update to GitHub repo


## zenodo-upload.py
import requests

params = {'access_token': '<your-access-token>'}

# Create the deposit resource
url = "https://sandbox.zenodo.org/api/deposit/depositions"
headers = {"Content-Type": "application/json"}

res = requests.post(
    url,

## Makefile
COMPOSE := docker-compose -p demouuid

start:
	$(COMPOSE) up -d
	sleep 3
	while $(COMPOSE) ps | grep -q database; do \
		$(COMPOSE) logs 2>/dev/null| grep -q 'MySQL init process done.' && break;\
		$(COMPOSE) logs 2>/dev/null| grep -i error && break;\
		$(COMPOSE) ps | grep -q Exit && break;\
	done

## bench.py
from __future__ import print_function
import time

def query_10k(cur):
    t = time.time()
    for _ in range(10000):
        cur.execute("SELECT 1,2,3,4,5")
        res = cur.fetchall()
        assert len(res) == 1
        assert res[0] == (1,2,3,4,5)

## so_read_url_write_file.py
"""
Code to write data read from a URL to a file

Based on an answer on SO:
http://stackoverflow.com/questions/22676/how-do-i-download-a-file-over-http-using-python/22721
"""

import urllib2

mp3file = urllib2.urlopen("http://www.example.com/songs/mp3.mp3")

## d3.slider.css
.d3-slider {
    position: relative;
    font-family: Verdana,Arial,sans-serif;
    font-size: 1.1em;
    border: 1px solid #aaaaaa;
    z-index: 2;
}

.d3-slider-horizontal {
    height: .8em;

## index.html
<!DOCTYPE html>
<html>

<head>
    <meta charset="utf-8">
    <meta name="keywords" lang="de" content="Zeitleiste, Zeitlinie, Zeitkarte, Geschichte, Chronologie">
    <meta name="keywords" lang="en" content="Timeline, Timemap, History, Chronology">
    <title>Timeline - Proof-of-concept</title>

    <!-- That's my local d3 path. When working locally, use your local path. -->

## .treehouse
1.3.1

## .block
license: gpl-3.0
height: 500
scrolling: no
border: yes
	import pandas as pd
	from tabulate import tabulate

	def pandas_df_to_markdown_table(df):
	# Dependent upon ipython
	# shamelessly stolen from https://stackoverflow.com/questions/33181846/programmatically-convert-pandas-dataframe-to-markdown-table
	from IPython.display import Markdown, display
	fmt = ['---' for i in range(len(df.columns))]
	df_fmt = pd.DataFrame([fmt], columns=df.columns)
	df_formatted = pd.concat([df_fmt, df])
	import requests
	import base64
	import json
	import datetime


	def push_to_repo_branch(gitHubFileName, fileName, repo_slug, branch, user, token):
	'''
	Push file update to GitHub repo
	import requests

	params = {'access_token': '<your-access-token>'}

	# Create the deposit resource
	url = "https://sandbox.zenodo.org/api/deposit/depositions"
	headers = {"Content-Type": "application/json"}

	res = requests.post(
	url,
	COMPOSE := docker-compose -p demouuid

	start:
	$(COMPOSE) up -d
	sleep 3
	while $(COMPOSE) ps \| grep -q database; do \
	$(COMPOSE) logs 2>/dev/null\| grep -q 'MySQL init process done.' && break;\
	$(COMPOSE) logs 2>/dev/null\| grep -i error && break;\
	$(COMPOSE) ps \| grep -q Exit && break;\
	done
	from __future__ import print_function
	import time

	def query_10k(cur):
	t = time.time()
	for _ in range(10000):
	cur.execute("SELECT 1,2,3,4,5")
	res = cur.fetchall()
	assert len(res) == 1
	assert res[0] == (1,2,3,4,5)
	"""
	Code to write data read from a URL to a file

	Based on an answer on SO:
	http://stackoverflow.com/questions/22676/how-do-i-download-a-file-over-http-using-python/22721
	"""

	import urllib2

	mp3file = urllib2.urlopen("http://www.example.com/songs/mp3.mp3")
	.d3-slider {
	position: relative;
	font-family: Verdana,Arial,sans-serif;
	font-size: 1.1em;
	border: 1px solid #aaaaaa;
	z-index: 2;
	}

	.d3-slider-horizontal {
	height: .8em;
	<!DOCTYPE html>
	<html>

	<head>
	<meta charset="utf-8">
	<meta name="keywords" lang="de" content="Zeitleiste, Zeitlinie, Zeitkarte, Geschichte, Chronologie">
	<meta name="keywords" lang="en" content="Timeline, Timemap, History, Chronology">
	<title>Timeline - Proof-of-concept</title>

	<!-- That's my local d3 path. When working locally, use your local path. -->