sany2k8

<?php

function pluralize( $count, $text )
{
    return $count . ( ( $count == 1 ) ? ( " $text" ) : ( " ${text}s" ) );
}

function finddiff($datetime1, $datetime2)
{
    $final_result = [];

sany2k8

<?php
require_once("PHPExcel/PHPExcel.php");
$phpExcel = new PHPExcel();

$styleArray = array(
	'font' => array(
		'bold' => true,
	)
);

sany2k8

You have to do 2 things in order to allow your container to access your host's postgresql database

1. Make your postgresql listen to an external ip address
2. Let this client ip (your docker container) access your postgresql database with a given user

Obs: By "Host" here I mean "the server where docker is running on".

Make your postgresql listen to an external ip address

Find your postgresql.conf (in case you don't know where it is)

$ sudo find / -type f -name postgresql.conf

sany2k8

# Initialize the scroll
page = es.search(
  index = 'yourIndex',
  doc_type = 'yourType',
  scroll = '2m',
  search_type = 'scan',
  size = 1000,
  body = {
    # Your query's body
    })

sany2k8

from pyelasticsearch import ElasticSearch
import pandas as pd
from time import time

root_path="/home/clemsos/Dev/mitras/"
raw_data_path=root_path+"data/"
csv_filename="week10.csv"

t0=time()

sany2k8

# coding: utf8
"""
Goal: import csv to database.

pip install pandas, numpy
"""

import pandas
import numpy as np

sany2k8

# -*- coding: utf-8 -*-

# import pandas and numpy package
import numpy as np
import pandas as pd

# List unique values in a DataFrame column
df['Column Name'].unique()

# To extract a specific column (subset the dataframe), you can use [ ] (brackets) or attribute notation.

sany2k8

import pandas as pd

# Read file
results = pd.read_csv("/tmp/data.csv", encoding='utf-8',sep=',', quoting=csv.QUOTE_ALL)

# Print rows
for row in results:
  print(row)
 
# Iterate over rows

sany2k8

Useful Pandas Snippets

A personal diary of DataFrame munging over the years.

Data Types and Conversion

Convert Series datatype to numeric (will error if column has non-numeric values)
(h/t @makmanalp)

sany2k8

# Redis Cheatsheet
# All the commands you need to know


redis-server /path/redis.conf  # start redis with the related configuration file
redis-cli                      # opens a redis prompt


# Strings.