marquicus

PostgreSQL Streaming Replication With Docker

The *.txt files here hold user and database parameters. Specifically, replication.txt contains the user/role and password to use for replication. Whereas database.txt contains an initial database, user/role and password to create on the master.

Run the master:

$ fig run -d master

Wait for it to start up completely. Start the slave:

marquicus

"""
formula.py - propositional formulas for Python
by Robin Wellner
Hereby, I waive all rights to this library, as described at <http://creativecommons.org/publicdomain/zero/1.0/>

Examples:

foo = Atom('foo')
bar = Atom('bar')

marquicus

import argparse
import pandas as pd


def gas_prices(input, filetype="csv"):
    """Getting gas prices by day and month

    1. Read csv or excel (assuming extension csv is a true csv file format, it might be another validations in real scenario)
    1.1 Datetime Index is for month
    2. Write to csv

marquicus

# 1. Main data wanted is daily prices. (I downloaded the Henry_Hub_Natural_Gas_Spot_Price.csv with view history as daily)

import pandas as pd

dfg = pd.read_csv('Henry_Hub_Natural_Gas_Spot_Price.csv', skiprows=4)
dfg.index = pd.to_datetime(dfg["Day"],format='%m/%d/%Y')
dfg.to_csv('gas_byday.csv', index=False)  # => first output gas_byday.csv file

# 1.1 Bonus points for doing other granularities (e.g. month) - do them in separate CSV files with sensible naming Resulting CSV should have two columns: Date and Price. You may need to normalize the data to get this and/or work out dates. For months the Date should be the first date of the month.

marquicus

#!/bin/bash

#
##
## Vendor: Zentek ST
##

DIRNAME=$(dirname $0)
APPMAIL="[email protected]"
APPVERSION="2.0"