class Hola:
    """ una clase que is amigable """

    # your code here


yo = Hola()

yo.saludar()     # should print the greeting

class Numbers:
    """ various number methods """


num = Numbers()
val = num.doubleit(5)
print(val)               # 10

val2 = num.doubleit(100)
print(val2)              # 200

import time

# your code here


obj = Time()
print(obj.get_time())  # should show the current time

import random

# your code here




obj = Random()

val = obj.get_rand(5)     # random number from 1-5
print(val)

val2 = obj.get_rand(18)   # random number from 1-18
print(val2)

# your code here



obj = Math()

mysum = obj.add(5, 10)        # 15
print(mysum)

mysum2 = obj.add(100, 150)    # 250
print(mysum2)

class Do:
    def something(self):
        print(self)


obj = Do()
obj2 = Do()

# your code here

class Be:
    """ this class is something! """


obj1 = Be()
print(f'object:  {obj1}')

print()

obj2 = Be()
print(f'object:  {obj2})

class Live:
    """ a class that just wants to live """
    # your __init__() code here


obj = Live(5)

# print obj.value here

class Say:
    def __init__(self, val):
        self.value = val

    # your code here


obj = Say(100)

vl = obj.get_value()
print(vl)                # 100

class Something:
    # your class variable here

    def __init__(self, xx):
        self.attr = xx

a = Something('hi')
b = Something('there')


# print cvar in 3 places here

# print .attr from each of the two instances here

class MyClass:
    cattr = 0

    # your classincrement(cls) method here


obj = MyClass()


obj.classincrement()

print(obj.cattr)          # should be 1
print(MyClass.cattr)      # should be 1

class Forecast:

    def __init__(self, forecast, high=0, low=0):
        self.text = forecast
        self.hightemp = high
        self.lowtemp = low

    def ftoc(temp):
        return (temp - 32) * 5 / 9

t = Forecast('Light rain', high=62, low=48)

print(t.ftoc(32))       # 0.0
print(t.ftoc(212))      # 100.0

# your code here


c = Counter(5)

print(c.counterval)    # 5

class Counter:
    def __init__(self, val):
        self.counterval = val

    # your code here


c = Counter(5)

c.increment()
c.increment()

print(c.counterval)    # 7

class Counter:
    def __init__(self, val):
        self.counterval = val

    def increment(self):
        self.counterval = self.counterval + 1

    # your code here


c = Counter(5)

c.increment()
c.increment()

print(c.counterval)    # 7

class Counter:
    # your class variable here

    def __init__(self, val):
        self.counterval = val

    def increment(self):
        self.counterval = self.counterval + 1
        # add the value of increment_value here

c = Counter(5)

c.increment()
c.increment()

print(c.counterval)    # 5 + (2 * increment_value)

import zipfile as zp

myzip = zp.ZipFile('myzip.zip', 'w')

# add names of files in the current directory
myzip.write()      # write 1st filename here
myzip.write()      # write 2nd filename here

myzip.close()

print('done')

import time

secs = time.time()

# print(time.ctime(secs))

# print(time.localtime(secs))

# time.sleep(5)

import datetime as dt

# mydate = dt.date(2019, 9, 3)

# mydate = dt.date.today()

# mydatetime = dt.datetime(2019, 9, 3, 12, 5, 30)

# mydatetime = dt.datetime.now()


#secs = time.time()
#time_elements = time.localtime(secs)
#print(time_elements)


# myinterval = dt.timedelta(days=3, seconds=120)

# newdate = mydate + myinterval

# print(newdate)

# print(newdate.strftime('%Y-%m-%d'))

# dt.datetime.strptime('2019-03-03', '%Y-%m-%d')

import random

myfloat = random.random()

# num = random.randint(10)

# num = random.randint(3,5)

# x = ['a', 'b', 'c']

# choice = random.choice(x)

import csv

fh = open('../dated_file.csv')
reader = csv.reader(fh)

for row in reader:
    print(row)

fh.close()


# wfh = open('../newfile.csv', 'w', newline='')
# writer = csv.writer(wfh)

# writer.writerow(['a', 'b', 'c'])

# wfh.close()

# Again, please be advised that you will not see writes to a file
# until you close the file with fh.close() or until the program
# ends execution.  This is particularly critical with Jupyter as
# it is basically a running program.

import openpyxl as ox


# read an Excel workbook from a file
# read_only=True will limit your actions to reading
wb = ox.load_workbook('../revenue.xlsx', read_only=True)


# show list of sheets within the workbook
print(wb.sheetnames)
  # ['transactions']


# access a single sheet within the workbook
ws = wb['transactions']


# loop through the entire worksheet and look at each row
for row in ws.iter_rows():

    # subscript out two fields from the row
    col1 = row[0].value
    col2 = row[1].value


# to skip rows (for example, headers) you can use min_row= argument:
for row in ws.iter_rows(min_row=2):

    # subscript out two fields from the row
    col1 = row[0].value
    col2 = row[1].value

# note that older versions of openpyxl may use the skip_rows= argument instead of min_row=.


# access one cell by Excel cellname
c = ws['A2']           # 'cell' object
print(c.value)          # the value in the cell

print(ws['B2'].value)   # access value in one statement

import sqlite3

conn = sqlite3.connect('../mydatabase.db')

cur = conn.cursor()

cur.execute("CREATE TABLE mytable (name TEXT, years INT, balance FLOAT)")

cur.execute("INSERT INTO mytable VALUES ('Joe', 23, 23.9)")
cur.execute("INSERT INTO mytable VALUES ('Marie', 19, 7.95)")
cur.execute("INSERT INTO mytable VALUES ('Zoe', 29, 17.5)")

conn.commit()


cur = conn.cursor()

rs = cur.execute('SELECT * FROM mytable')

for row in rs:
    print(row)

import pandas as pd
import sqlite3

df = pd.read_csv('../dated_file.csv')

# write DataFrame to excel
#df.to_excel('../dated_file.xls')

# read from database through query
# conn = sqlite3.connect('../testdb.db')
# df = pd.read_sql('SELECT * FROM test', conn)

df = pd.read_csv('../dated_file.csv')


# sum, average, etc. a column



# create a new column

# select rows thru a filter

# groupby aggregation

# groupby bar chart


# weather temp line chart

import bs4

fh = open('../dormouse.html')

text = fh.read()

page = bs4.BeautifulSoup(text, 'html.parser')

print(page.title)

fh.close()

import requests
import bs4

response = requests.get('http://www.nytimes.com')

page = bs4.BeautifulSoup(response.text, 'html.parser')

print(page.title)

import re

line = 'a phone number:  213-298-1990'

matchobj = re.search(r'(\d\d\d)\-(\d\d\d)\-(\d\d\d\d)', line)

print(matchobj.group(1))

import subprocess

subprocess.call(['python', 'hello.py'])

# out = subprocess.check_output(['python', 'hello.py')

import textwrap

text = ("This is some really long text that we would like to wrap.  "
        "Wouldn't you know it, there's a module for that!  ")


items = textwrap.wrap(text, 10)

print('\n'.join(items))