import pandas as pd 
from google.colab import drive
drive.mount("/content/drive")

DATA_PATH = "/content/drive/MyDrive/Colab Notebooks/data/supermarket_sales.csv"
sales = pd.read_csv(DATA_PATH)
sales

import matplotlib
import seaborn as sns
print(matplotlib.__version__)
print(sns.__version__)

import matplotlib.pyplot as plt

dates = [
    '2021-01-01', '2021-01-02', '2021-01-03', '2021-01-04', '2021-01-05',
    '2021-01-06', '2021-01-07', '2021-01-08', '2021-01-09', '2021-01-10'
]
min_temperature = [20.7, 17.9, 18.8, 14.6, 15.8, 15.8, 15.8, 17.4, 21.8, 20.0]
max_temperature = [34.7, 28.9, 31.8, 25.6, 28.8, 21.8, 22.8, 28.4, 30.8, 32.0]

# 앞으로 여러분들이 아래와 같이 코드를 작성해주시면 됩니다.
flg, ax = plt.subplots(nrows = 1, ncols = 1, figsize = (10, 6)) # 시각화 기초 해심



ax.plot(dates, min_temperature, label = "Min Temp.")
ax.plot(dates, max_temperature, label = "Max Temp.")
ax.legend()
plt.show()

!pip install yfinance --upgrade --no-cache-dir

import yfinance as yf
data = yf.download("AAPL", start = "2019-08-01", end = "2022-03-23")
ts = data['Open']
print(ts.head())
print(type(ts))

import matplotlib.pyplot as plt
plt.plot(ts)
plt.title("Stock Market of AAPL") # 구글 코랩에서 한글 타이틀은 인식을 못하여 나중에 세팅해야함
plt.xlabel("Date")
plt.ylabel("Open Price")
plt.show()

import matplotlib.pyplot as plt

fig, ax = plt.subplots() #fig 는 겉 테두리
ax.plot(ts)
ax.set_title("Stock Market of AAPL")
ax.set_xlabel("Date")
ax.set_ylabel("Open Price")
plt.show()

calendar.month_name[1:13]

import matplotlib.pyplot as plt
import numpy as np
import calendar # 날짜를 관장하는 라이브러리

month_list = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12]
sold_list = [300, 400, 550, 900, 600, 960, 900, 910, 800, 700, 550, 450]

fig, ax = plt.subplots(figsize = (10, 6))
barplots = ax.bar(month_list, sold_list)

print("barplots :", barplots)

for plot in barplots:
  print(plot)
  # print(plot.get_height())
  # print(plot.get_x())
  # print(plot.get_y())
  # print(plot.get_width())
  height = plot.get_height()
  ax.text(plot.get_x() + plot.get_width()/2., height, height, ha = 'center', va = 'bottom')

plt.xticks(month_list, calendar.month_name[1:13], rotation = 90)
plt.show()

import seaborn as sns

tips = sns.load_dataset("tips")
print(tips.info())
x = tips['total_bill']
y = tips['tip']

# 산점도
fig, ax = plt.subplots(figsize = (10,6))
ax.scatter(x, y)
ax.set_xlabel('Total Bill')
ax.set_ylabel('Tip')
plt.show()

label, data = tips.groupby('sex')
# print(label)
# print(data)

tips['sex_color'] = tips['sex'].map({'Male': '#2521F6', 'Female': '#EB4036'})
# print(tips.head())

fig, ax = plt.subplots(figsize = (10, 6))
for label, data in tips.groupby('sex'):
  ax.scatter(data['total_bill'], data['tip'], label = label, color = data['sex_color'], alpha = 0.5)
  ax.set_xlabel('Total Bill')
  ax.set_ylabel('Tip')

ax.legend() # 범례
plt.show()

from IPython.core.pylabtools import figsize
import matplotlib.pyplot as plt
import seaborn as sns

tips = sns.load_dataset("tips")
# print(tips.info())

fig, ax = plt.subplots(figsize=(10, 6))
sns.scatterplot(x = 'total_bill', y = 'tip', hue = 'sex', data = tips)
plt.show()

# 두개의 그래프를 동시에 표현
fig, ax = plt.subplots(nrows=1, ncols=2, figsize=(15, 5))
sns.regplot(x = "total_bill", y = "tip", data = tips , ax = ax[1], fit_reg = True)
ax[1].set_title("with linear regression line")

sns.regplot(x = "total_bill", y = "tip", data = tips , ax = ax[0], fit_reg = False)
ax[0].set_title("without linear regression line")
plt.show()

sns.countplot(x = "day", data = tips)
plt.show()

print(tips['day'].value_counts().index)
print(tips['day'].value_counts().values)
print(tips['day'].value_counts(ascending=True)) # 오름차순

fig, ax = plt.subplots()
ax = sns.countplot(x = "day", data = tips, order = tips['day'].value_counts().index)

for plot in ax.patches:
  # print(plot)
  height = plot.get_height()
  ax.text(plot.get_x() + plot.get_width()/2., height, height, ha = 'center', va = 'bottom')

ax.set_ylim(-5, 100) # y축 값 변경
plt.show()

import pandas as pd
print(pd.__version__)

temp_dic = {"coll" : [1, 2, 3],
            "col2" : [3, 4, 5]}
df = pd.DataFrame(temp_dic)
print(type(df))
print(df)

temp_dic = {'a' : 1 , "b" : 2, "c" : 3}
ser = pd.Series(temp_dic)
print(type(ser))
print(ser)

from google.colab import drive
drive.mount('/content/drive')

DATA_PATH = '/content/drive/MyDrive/Colab Notebooks/data/Lemonade2016.csv'
juice = pd.read_csv(DATA_PATH)
juice

# R install.pakages("패키지명")
# 파이썬 라이브러리 설치 코드에서 실행 (x)
# 터미널에서 설치
# 방법 1. conda 설치
# --> 아나콘다 설치 후, conda 설치 (데이터 과학)
# 방법 2. pip 설치 (개발 + 데이터과학 + 그외)
# --> 아나콘다 설치 안함 / 파이썬만 설치

# git bash 열고, pip install numpy
# pip install numpy

import numpy
print(numpy.__version__)

import numpy as np
print(np.__version__)

temp = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10]
arr = np.array(temp)
print(arr)
print(temp)

print(type(temp))
print(type(arr))

arr[4:8]

np.mean(arr)
np.sum(arr)
np.median(arr)
np.std(arr)

math_scores = [90, 80, 88]
english_scores = [80, 70, 90]

total_scores = math_scores + english_scores
total_scores

math_scores = [90, 80, 88]
english_scores = [80, 70, 90]

math_arr = np.array(math_scores)
english_arr = np.array(english_scores)

total_scores = math_arr + english_arr
total_scores

np.min(total_scores)

np.max(total_scores)

math_scores = [2, 3, 4]
english_scores = [1, 2, 3]

math_arr = np.array(math_scores)
english_arr = np.array(english_scores)

# 사칙연산
print("덧셈:", np.add(math_arr, english_arr))
print("뺄셈:", np.subtract(math_arr, english_arr))
print("곱셈:", np.multiply(math_arr, english_arr))
print("나눗셈:", np.divide(math_arr, english_arr))
print("거듭제곱:", np.power(math_arr, english_arr))

temp_arr = np.array(20)
print(temp_arr)
print(type(temp_arr))
print(temp_arr.shape)

# 1차원 배열
temp_arr = np.array([1, 2, 3])
print(temp_arr)
print(type(temp_arr))
print(temp_arr.shape)
print(temp_arr.ndim) # 몇 차원인지 알아보는 법

# 2차원 배열
temp_arr = np.array([[1, 2, 3], [4, 5, 6]])
print(temp_arr)
print(type(temp_arr))
print(temp_arr.shape) # 2 * 3 배열이다
print(temp_arr.ndim)

# 3차원 배열
temp_arr = np.array([[[1, 2, 3], [4, 5, 6]], [[1, 2, 3], [4, 5, 6]]])
print(temp_arr)
print(type(temp_arr))
print(temp_arr.shape)
print(temp_arr.ndim)

temp_arr = np.array([1, 2, 3, 4], ndmin = 2) # ndmin으로 인해 2차원 배열로 바뀜
print(temp_arr)
print(type(temp_arr))
print(temp_arr.shape)
print(temp_arr.ndim)

temp_arr = np.trunc([-1.23, 1.23])
temp_arr # 소수점 아래 자리가 절삭됨.

temp_arr = np.fix([-1.23, 1.23])
temp_arr

temp_arr = np.around([-1.23789, 1.23789], 4)
temp_arr

temp_arr = np.round([-1.23789, 1.23789], 4)
temp_arr

temp_arr = np.floor([-1.23789, 1.23789]) # 내림
temp_arr

temp_arr = np.ceil([-1.23789, 1.23789]) # 올림
temp_arr

temp_arr = np.arange(5)
temp_arr

temp_arr = np.arange(1, 11, 3)
temp_arr

zero_arr = np.zeros((2, 3))
print(zero_arr)
print(type(zero_arr))
print(zero_arr.shape)
print(zero_arr.ndim)
print(zero_arr.dtype) # float64 -> 64는 bit

temp_arr = np.ones((4, 5), dtype = "int32") # 데이터 타입도 인위적으로 수정 가능
print(temp_arr)
print(type(temp_arr))
print(temp_arr.shape)
print(temp_arr.ndim)
print(temp_arr.dtype)

temp_arr = np.ones((2, 6), dtype = "int32")
temp_res_arr = temp_arr.reshape(2, 2, 3) # (5, 3)을 했을때 cannot reshape array of size 12 into shape (5,3)
print(temp_res_arr)                   # 사이즈를 12로 바꾸면 되서 4, 3 또는 3, 4 등 바꿔주면 됨.
print(type(temp_res_arr))
print(temp_res_arr.shape)
print(temp_res_arr.ndim)
print(temp_res_arr.dtype)

temp_arr = np.ones((12, 12), dtype = "int32")
temp_res_arr = temp_arr.reshape(5, -1) # np.ones(12, 12) -> 12*12 = 144 약수가 아니면 error
print(temp_res_arr) 
print(type(temp_res_arr))
print(temp_res_arr.shape)
print(temp_res_arr.ndim)
print(temp_res_arr.dtype)

temp_arr = np.arange(10)
temp_arr

# 5보다 작은 값은 원래값으로 반환
# 5보다 큰 값은 원래 값 * 10
np.where(temp_arr < 5, temp_arr, temp_arr * 10)

# 0 - 100 까지의 배열을 만들고, 50보다 작은 값은 곱하기 10, 나머지는 그냥 원래 값으로 반환
# np.where 은 조건식이 하나만 필요할 떄 사용
temp_arr = np.arange(101)
# temp_arr
np.where(temp_arr < 50, temp_arr * 10, temp_arr)

temp_arr = np.arange(10)
temp_arr

# 5보다 큰 값은 곱하기 2, 2보다 작은 값은 더하기 100

condlist = [temp_arr > 5, temp_arr < 2]
choicelist = [temp_arr * 2, temp_arr + 100]
np.select(condlist, choicelist, default = temp_arr)

class Person:      # 대문자소문자 입력.
  
  # class attribute
  country = "korean"

  # instance attribute
  def __init__(self, name, age):   # def __init__(self) 고정적 default
    self.name = name
    self.age = age

  # instance method 정의
  def singing(self,songtitle, sales):
    return "{} 판매량 {} 된 {}을 노래합니다.".format(self.name, sales, songtitle)

if __name__ == "__main__":
  kim = Person("Kim", 100)
  lee = Person("Lee", 100)

  # access class attribute
  print("kim은 {}".format(kim.__class__.country))
  print("lee는 {}".format(lee.__class__.country))

  # call instance
  print(kim.singing("A", 10))
  print(lee.singing("B", 200))

class Parent:
  # instance attribute
  def __init__(self, name, age):
    self.name = name
    self.age = age

  # instance method 정의
  def whoAmI(self):
    print(" I am Parent!!")

  def singing(self,songtitle):
    return "{} {}을 노래합니다.".format(self.name, songtitle)

  def dancing(self):
    return "{} 현재 춤을 춥니다.".format(self.name)

class Child(Parent):
  def __init__(self, name, age):
    # super() function
    super().__init__(name, age)
    print("Child Class is ON")

  def whoAmI(self):
    print("I am Child")

  def studying(self):
    print("I am Fast Runner")


if __name__ == "__main__":
  child_kim = Child("kim", 15)
  parent_kim = Parent("kim", 45)
  print(child_kim.dancing())
  print(child_kim.singing("연애"))
  #print(parent_kim.studying()) # AttributeError: 'Parent' object has no attribute 'studying' **parent 클래스에 정의 되어있지 않아서 에러가 남"
  child_kim.whoAmI()
  parent_kim.whoAmI()

class TV:

  # init constructor
  def __init__(self):
    self.__maxprice = 500

  def sell(self):
    print("Selling Price: {}".format(self.__maxprice))

  def setMaxPrice(self, price):
    self.__maxprice = price

if __name__ == "__main__":
  tv = TV()
  tv.sell()

  # change price
  # 안 바뀌는 코드의 예시
  tv.__maxprice = 1000
  tv.sell()

  # setMaxPrice
  # 값을 바꿀 수있다!? 외부의 입력값을 업데이트 할 수 있다!
  tv.setMaxPrice(1000)
  tv.sell()

class Employee:

  # init constructor
  # nmae , salary
  def __init__(self, name, salary = 0):
    self.name = name

    # 조건문 추가
    if salary > 0:
      self.salary = salary
    else:
      self.salary = 0
      print("급여는 0원이 될수 없다!. 다시 입력하십시오!!")

  def update_salary(self, amount):
    self.salary += amount

  def weekly_salary(self):
    return self.salary / 7

if __name__ == "__main__":
  emp01 = Employee("Winters", -50000)
  print(emp01.name)
  print(emp01.salary)
  emp01.salary += 1500
  print(emp01.salary)
  emp01.update_salary(3000)
  print(emp01.salary)
  week_salary = emp01.weekly_salary()
  print(week_salary)

class Person:
  """
  사람을 표현하는 클래스
  

 
  Attributes
  ------------
  name : str
    name of the person

  age : int
    age of the person

  Methods
  -------------
 
  info(additional=""):
    prints the person's name and age
  """
  def __init__(self, name, age):
    """
    Constructs all the neccessary attributes for the person object
  
    Parameters(매개변수)
    -------------------------
      name : str
        name of the person

      age : int
        age of the person
    """

    self.name = name
    self.age = age

  def info(self, additional = None):
    """
    귀찮음...
    
    Parameters
    --------------
      additional : str, optional
        more info to be displayed (Default is None) / A, B, C


    Returens
    -----------
      None

    """

    print(f'My name is {self.name}. I am {self.age} years old. ' + additional)

if __name__ == "__main__":
    person = Person("Evan", age = 20)
    person.info("나의 직장은 00이야")
    help(Person)

# 리스트
book_list = ["A","B","C"]
# append, extend, insert, remove, pop, etc

# 튜플
book_tuple = ("A", "B", "c")
# 수정 삭제가 불가능하다

# 딕셔너리
book_dictionary = {"책 제목" : ["A", "B"], "출판년도" :[2011, 2002]}
# keys(), values(), items(), get()

if True:
  print("코드 실행")
elif True:
  print("코드 실행")
else:
  print("코드 실행")

for i in range(3):
  print(i+1, "안녕하세요")

book_list = ["프로그래밍 R", "혼자 공부하는 머신러닝"]
for book in book_list:
  print(book)

strings01 = "Hello World"
for char in strings01:
  print(char)