-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathreader1.py
37 lines (32 loc) · 5.04 KB
/
reader1.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
import pandas as pd
from io import StringIO
# CSV data
csv_data = """
sno,goodsno,opt1,opt2,price,consumer,supply,price_origin,consumer_origin,stock,link,go_is_display,values_hash,is_sellers_supply_option,total_additional_price,stock_sync_code,__transaction_time,__source_connector_time,__operation_type,__deleted,_yyyymmdd
154755053,15757371,진베이지,ONE SIZE,15960,16800,3940,15960,16800,0,0,1,3e6270dbc22206313a49ae1bcbe3cd723a3db731cd19957ae616c1b0f3306d7a,false,0,,1722432738000,1722432738939,u,false,2024-07-31T22:32:18.000+09:00
149689064,14956699,❤️A6 지퍼바인더 단품,블랙,8900,19000,0,8900,19000,987,0,1,4a6ba3eb17a5555fedc2b860d71c15dcabed0b2a46cb8a867b6f8cc4c8a83cec,false,-1000,,1722434973000,1722434973029,u,false,2024-07-31T23:09:33.000+09:00
149689064,14956699,❤️A6 지퍼바인더 단품,블랙,8900,19000,0,8900,19000,986,0,1,4a6ba3eb17a5555fedc2b860d71c15dcabed0b2a46cb8a867b6f8cc4c8a83cec,false,-1000,,1722436055000,1722436057037,u,false,2024-07-31T23:27:35.000+09:00
149689064,14956699,❤️A6 지퍼바인더 단품,블랙,8900,19000,0,8900,19000,987,0,1,4a6ba3eb17a5555fedc2b860d71c15dcabed0b2a46cb8a867b6f8cc4c8a83cec,false,-1000,,1722437137000,1722437137504,u,false,2024-07-31T23:45:37.000+09:00
58562234,4801960,7cm,한개만 구매 ❤,15900,17900,5000,15900,17900,969,0,1,542e072543d0589d4406938c16095727680b157516dfc4e94ef5fe23d8112dcb,false,-1000,,1722438191000,1722438193803,u,false,2024-08-01T00:03:11.000+09:00
157704972,16226809,one,3,13000,0,10000,13000,0,1,0,1,0e81c971b7e1da0f0fb50149937d740b275ea4633d70119257ef91c3dcc48e84,false,-1000,,1722438924000,1722438924961,u,false,2024-08-01T00:15:24.000+09:00
212487670,22631102,블루,"FREE (구매 감사 기념할인 1,000원) 7/12 ~8/4일 까지)",23900,0,19000,23900,0,81,0,1,189801c7033045aa7026678ffffbbde3d49875a518946f5f3d306c5d754f249e,false,-1000,,1722433239000,1722433240348,u,false,2024-07-31T22:40:39.000+09:00
149689066,14956699,❤️A6 지퍼바인더 단품,화이트,8900,19000,0,8900,19000,973,0,1,08da7a3d821fedb4b460e698f663b266ac06386ba16ae3e41d5e1ffe77b30646,false,-1000,,1722435100000,1722435100345,u,false,2024-07-31T23:11:40.000+09:00
149689066,14956699,❤️A6 지퍼바인더 단품,화이트,8900,19000,0,8900,19000,974,0,1,08da7a3d821fedb4b460e698f663b266ac06386ba16ae3e41d5e1ffe77b30646,false,-1000,,1722436015000,1722436015485,u,false,2024-07-31T23:26:55.000+09:00
152443566,3395927,옵션선택,(추가상품) 5V 3A 어댑터 (검정),6000,34000,0,6000,34000,999987,0,1,5ce6891d4ae98343ef8c8d0e8ad5f666981a9c09fe3aa3b44383462a99203b43,false,-1000,,1722434590000,1722434591538,u,false,2024-07-31T23:03:10.000+09:00
181852992,11153165,블랙,여름 할인 s,26800,0,19000,26800,0,995,0,1,2fe839046e04e4c8234862e7b3bafbb9e23882253fa62f0c1ee02fcfe37446d3,false,-1000,,1722437902000,1722437903044,u,false,2024-07-31T23:58:22.000+09:00
192211796,10294625,구매하실 제품과 수량을 정확하게 선택해주세요,마이멜로디(긴끈X),18900,24000,0,18900,24000,0,0,1,8b241342fec7873adfa493136066efa697d8365479a603d0b927ffdd064047a7,false,-1000,,1722435735000,1722435735927,u,false,2024-07-31T23:22:15.000+09:00
149689059,14956699,❤️A6 지퍼바인더 단품,블루,8900,19000,0,8900,19000,988,0,1,e41f2ee03bfdb30f817056b4a12de73a4cf6f6386dd523ddea3154f911953cc2,false,-1000,,1722436425000,1722436425950,u,false,2024-07-31T23:33:45.000+09:00
149689059,14956699,❤️A6 지퍼바인더 단품,블루,8900,19000,0,8900,19000,989,0,1,e41f2ee03bfdb30f817056b4a12de73a4cf6f6386dd523ddea3154f911953cc2,false,-1000,,1722436457000,1722436457834,u,false,2024-07-31T23:34:17.000+09:00
149689062,14956699,❤️A6 지퍼바인더 단품,아보카도,8900,19000,0,8900,19000,996,0,1,a575399d7d75ffd149bb53f6610e3304c0e5d992e96c2f022579b64fa1309ce0,false,-1000,,1722436425000,1722436425950,u,false,2024-07-31T23:33:45.000+09:00
149689062,14956699,❤️A6 지퍼바인더 단품,아보카도,8900,19000,0,8900,19000,997,0,1,a575399d7d75ffd149bb53f6610e3304c0e5d992e96c2f022579b64fa1309ce0,false,-1000,,1722436458000,1722436458127,u,false,2024-07-31T23:34:18.000+09:00
21323273,2097956,★여름버전_블랙,숏,11500,0,0,11500,0,991,0,1,fafafdc61c9072018b500bbb9840f4681daba676214598428155afdc893a8e8b,false,-1000,,1722436624000,1722436626133,u,false,2024-07-31T23:37:04.000+09:00
180208476,19139213,★2개이상 구매 (할인O),01.종아리 압박밴드(24AB070)_베이지,4900,11900,12900,4900,11900,9970,0,1,83aa927622c065cb271abc4541b82b32d2e547d4c8146ac35a63478f5e5d2ddf,false,-1000,,1722439405000,1722439406121,u,false,2024-08-01T00:23:25.000+09:00
180208479,19139213,★2개이상 구매 (할인O),02.허벅지 압박밴드(24AB071)_블랙,4900,11900,12900,4900,11900,9972,0,1,814ff020929129cf2c3dc4cd80c05d826116b2f6f875aa911805642a0db565de,false,-1000,,1722439405000,1722439406122,u,false,2024-08-01T00:23:25.000+09:00
"""
# Create DataFrame
df = pd.read_csv(StringIO(csv_data))
# Sort by the last column "_yyyymmdd"
df_sorted = df.sort_values(by="_yyyymmdd")
# Display the sorted DataFrame
# import ace_tools as tools; tools.display_dataframe_to_user(name="Sorted Order Data", dataframe=df_sorted)
print(df_sorted)