# -*- coding: utf-8 -*-
"""
Created on Fri Jun  4 12:19:40 2021

@author: Sim
"""

import pandas as pd
import numpy as np

df = pd.DataFrame([[90, 89, 70], [99, 98, 97], [70, 65, 78], [50, 55, 60], [80,87,90]],
                  index=['김철수', '여인선', '박이슬','이호동', '최은수'],
                  columns=['stat','language', 'math'])
df.apply(np.mean, axis=0)
df.apply(lambda x: x[0]+x[1]+x[2], axis=1)
df.apply(np.sum, axis=1)

def mynorm(x):
    nscore = (x - np.min(x)) / (np.max(x) - np.min(x))
    return(nscore)
def myst(x):
    nscore = (x - np.mean(x)) / np.std(x)
    return(nscore)

df.apply(mynorm, axis='index')
df.apply(myst)