<jupyter_start><jupyter_text>데이터 집합에있는 사용자 목록```USER_ID_hash : User ID (VARCHAR232) REG_DATE : 가입일 (DATE)SEX_ID : 사용자 성별 (CHAR)AGE : 나이 (NUMBER4)WITHDRAW_DATE : 가입해지일)PREF_NAME : 현 거주지 ```<jupyter_code>df_train_user_list = pd.read_csv('../data/user_list.csv')
df_train_user_list.tail()
#데이터 집합에있는 사용자 목록
print('USER_ID_hash' ,':', len(df_train_user_list.groupby('USER_ID_hash').count()))
print('PREF_NAME' ,':', len(df_train_user_list.groupby('PREF_NAME').count()))
print('WITHDRAW_DATE' ,':', len(df_train_user_list.groupby('WITHDRAW_DATE').count()))

% matplotlib inline
import matplotlib
## matplotlib 한글사용
from matplotlib import rc
rc('font', family='AppleGothic')
mpl.rcParams['axes.unicode_minus'] = False
plt.figure(figsize=(17,6))
def show_bar(df,col_name):
    plt.figure(figsize=(20,6))
    df2 = pd.DataFrame(df[col_name])
    counts = df2.groupby([col_name]).size().reset_index(name='Counts')
    print(counts)
    y = counts['Counts']
    x = counts[col_name]
    plt.bar(x, y)
    plt.show()
col_name = ['SEX_ID', 'AGE','PREF_NAME']
for col in col_name:
    show_bar(df_train_user_list, col)<jupyter_output>SEX_ID  Counts
0      f   10983
1      m   11890
StarcoderdataJupyterStructuredCleanDedup