지방이의 Data Science Lab

[SAS] (SUBSTR, TRANWRD) 글자추출, 대체

Data Analysis/SAS 2022. 5. 21. 16:43
[python] np.array를 pd로 다시 맵핑하기

1 2 3 4 5 6 7 8 9 10 my_2darray = np.array([[1, 2], [3,4], [5, 6]]) my_2darray my_dict = {"a": ['1', '2', '3'], "b": ['4', '5', '6']} df_temp = pd.DataFrame(my_dict, index = pd.date_range('2019-10-14', periods=3)) df_temp print(df_temp.shape) pd.DataFrame(my_2darray.reshape(df_temp.shape), columns=df_temp.columns, index=df_temp.index)
Data Analysis/Python 2021. 7. 28. 18:24
[python] map함수

1 2 3 4 5 6 7 my_dict = {"a": ['갑', '을'], "b": ['1', '2'], "c": ['2', '4']} df_temp = pd.DataFrame(my_dict) pd.DataFrame(my_dict) temp = {'갑': 'Master1', '을': 'Master2'} df_temp['a1'] = df_temp['a'].map(temp) df_temp
Data Analysis/Python 2021. 7. 28. 18:04
[python] agg 함수

1 2 3 4 5 6 my_dict = {"a": ['갑', '을', '을', '갑'], "b": ['1', '2', '2', '4']} df_temp = pd.DataFrame(my_dict) pd.DataFrame(my_dict) df_temp= df_temp.groupby(['a']).agg(sum_val = ('b',np.sum)).reset_index() df_temp
Data Analysis/Python 2021. 7. 28. 18:03
[Python] 날짜 데이터 파생변수

1 2 3 4 5 import pandas as pd data = pd.read_csv('temp.csv', parse_dates=['log_time'], infer_datetime_format = True) data['year'], data['month'], data['quarter'] = \ (data['log_time'].dt.year, data['log_time'].dt.month, data['log_time'].dt.quarter)
Data Analysis/Python 2021. 2. 24. 23:20
Prev 1 2 3 4 ··· 29 Next