import pandas as pd
df1 = pd.read_csv("./sungjuk.csv")
df1
import pandas as pd
import seaborn as sns
df2 = sns.load_dataset('titanic')
df2
df1['국어']
df1[['국어','영어']]
df1.국어
df1.loc[1]
df1.iloc[1]
df1.loc[1,'이름']
#df1.loc[[1,2], '이름']
#df1.loc[[1,2], ['이름', '국어']]
#df1.loc[1:3]
#df1.loc[1:3, '이름':'수학']
#df1.iloc[1,1]
#df1.iloc[[1,2],1]
#df1.iloc[[1,2],[1,2]]
#df1.iloc[1:3]
#df1.iloc[1:3, 1:3]
import pandas as pd
df = pd.DataFrame(
[['hong',90, 88, 78], ['gil',95, 89,98], ['dong',85, 98, 67] ]
, columns=['name','kor', 'eng', 'mat']
, index=['2', '4', '6']
)
df
#df.loc[2]
#df.iloc[2]
#df.loc['2']
import pandas as pd
df = pd.DataFrame(
{ 'name': ['hong', 'gil', 'dong'],'kor' :[90, 95, 85],
'eng' : [88, 89, 98], 'mat' : [78, 76, 67]}
)
df.columns = ['name','kor', 'eng', 'mat']
df.index = [202100001,202100002,202100003]
df
#df.loc[2]
#df.loc[202100001]
#df.loc['202100001']
#df.iloc[2]
#df.iloc['202100001']
df3 = df.copy()
#df3['kor'] = 100
#df3
#df3.loc[202100002] = ['길', 100, 100, 100]
#df3
#df3.loc[202100002, 'kor'] = 100
#df3
#df3.loc[202100002, ['kor', 'eng']] = 100
#df3
#df3.loc[202100002, ['kor', 'eng']] = [5, 6]
#df3
df3 = df.copy()
#df3['sci'] = 100
#df3
#df3['sci'] = [10, 20, 30]
#df3
#df3['sci'] = df3['kor'] * 2
#df3
#df3.loc[202100004] = 100
#df3
#df3.loc[202100004] = ['sir', 100, 100, 100]
#df3
#df3.drop('name', axis=1)
#df3
#df3.drop('name', axis=1, inplace=True)
#df3
#df3 = df3.drop('name', axis=1)
#df3
#df3.drop(202100002, axis=0)
#df3
#df3.drop(202100002, axis=0, inplace=True)
#df3
#df3 = df3.drop(202100002, axis=0)
#df3
df3 = df.copy()
#df3.transpose()
#df3
#df3.transpose(inplace=True)
#df3
#df3 = df3.transpose()
#df3
#df3.T
#df3
#df3 = df3.T
#df3
df3 = df.copy()
df3
#df3.set_index('name')
#df3
#df3 = df3.set_index('name')
#df3
df3.set_index('name', inplace=True)
df3
df3.loc['hong':'gil']
df3 = df.copy()
df3
df3 = df3.sort_index(ascending=False)
df3