온라인 채널 제품 판매량 예측 AI 온라인 해커톤

채용 | 알고리즘 | 정형 | 시계열 | LG Aimers | 수요 예측 | SFA

Prize : 본선 진출
1,769명 마감

Practice

Overview Data Code (share) Talk Leaderboard

Submission

시계열 데이터 쌍으로 만드는 방법

iiioo24

2023.08.25 21:34 1,474 Views

['대분류',

'중분류',

'소분류',

'브랜드',

'2022-01-01_x',

'2022-01-02_x',

'2022-01-03_x',

'2022-01-04_x',

'2022-01-05_x',

'2022-01-06_x',

'2022-01-07_x',

'2022-01-08_x',

'2022-01-09_x',

'2022-01-10_x',

'2022-01-11_x',

'2022-01-12_x',

'2022-01-13_x',

'2022-01-14_x',

'2022-01-01_y',

'2022-01-02_y',

'2022-01-03_y',

'2022-01-04_y',

'2022-01-05_y',

'2022-01-06_y',

'2022-01-07_y',

'2022-01-08_y',

'2022-01-09_y',

'2022-01-10_y',

'2022-01-11_y',

'2022-01-12_y',

'2022-01-13_y',

'2022-01-14_y',

'2022-01-15_y',

'2022-01-16_y',

'2022-01-17_y',

'2022-01-18_y',

'2022-01-19_y',

'2022-01-20_y',

'2022-01-21_y',

'2022-01-22_y',

'2022-01-23_y',

'2022-01-24_y',

'2022-01-25_y',

'2022-01-26_y',

'2022-01-27_y',

'2022-01-28_y',

'2022-01-29_y',

'2022-01-30_y',

'2022-01-31_y',

'2023-04-03_y',

'2023-04-04_y']

위와 같이 되어있는 데이터를 '2022-01-01_x'와 '2022-01-01_y'를 한쌍의 입력데이터로 만들려면 for문을 어떻게 작성해야 될까요??ㅠ

total_data = pd.merge(train_data, brand_data, on = '브랜드')

col_list = total_data.columns.tolist()

for i in len(range(col_list)):

for j in len(range(col_list)):

new_col_list = [i for i in range(train_data) + str('_x')] + [j for j in range(brand_data) + str('_y')]

new_col_list

위와 같이 작성해봤는데

---------------------------------------------------------------------------
TypeError                                 Traceback (most recent call last)
<ipython-input-28-e3af58be10c1> in <cell line: 4>()
      2 col_list = total_data.columns.tolist()
      3 
----> 4 for i in len(range(col_list)):
      5   for j in len(range(col_list)):
      6     new_col_list = [i for i in range(train_data) + str('_x')] + [j for j in range(brand_data) + str('_y')]

TypeError: 'list' object cannot be interpreted as an integer

이렇게 error가 떠서요ㅠ ㅠㅠㅠ

Comments 6개

로그인이 필요합니다

comment

0 / 1000