무회blog

## testFile 에서 haha 단어가 들어가지 않은 행 출력(필터기능) cat testFile.out | grep -nv haha ## testFile.csv 에서 구분자가 , (콤마) 이며 ## 2번째 필드/컬럼 추출 cut -d ,- f 2 testFile.csv cut

SELECT '20220301' DT, '3.1절' CMT FROM DUAL UNION ALL SELECT '20220101' DT, '신정' CMT FROM DUAL UNION ALL SELECT '20220124' DT, '구정' CMT FROM DUAL UNION ALL SELECT '20220127' DT, '신정대휴' CMT FROM DUAL UNION ALL SELECT '20220415' DT, '총선' CMT FROM DUAL UNION ALL SELECT '20220430' DT, '석탄일' CMT FROM DUAL UNION ALL SELECT '20220505' DT, '키즈' CMT FROM DUAL UNION ALL SELECT '20220815' DT, '광복절' CMT FROM..

SELECT TO_CHAR(TO_DATE('20221201'),'W') AS 월_WEEK FROM DUAL; -- 월주차 SELECT TO_CHAR(TO_DATE('20221125'),'W') AS 월_WEEK FROM DUAL; -- 월주차 select * from nls_session_parameters; -- 한글 설정 값 select to_char(TO_DATE('20221201'), 'day') from dual ; -- 목요일 select to_char(TO_DATE('20221201'), 'dy') from dual ; -- 목 select to_char(TO_DATE('20221201'), 'd') from dual ; -- (1:일, 2:월, 3:화, 4:수, 5:목, 6:금, 7:토) ..

-- 주차에 속한 일주일 구하기 SELECT '20220101', TO_CHAR( TO_DATE('20220101','YYYYMMDD') ,'YYYY-IW') AS YW , TO_CHAR( TO_DATE('20220101','YYYYMMDD') +( 1 - TO_CHAR(TO_DATE('20220101','YYYYMMDD') - 1, 'D') ), 'YYYY-MM-DD') AS START_DATE , TO_CHAR( TO_DATE('20220101','YYYYMMDD') +( 1 + 6 - TO_CHAR(TO_DATE('20220101','YYYYMMDD') - 1, 'D') ), 'YYYY-MM-DD') AS END_DATE FROM DUAL; SELECT TO_CHAR( TO_DATE('2022010..

import encodings from typing import Sequence from pandas import concat from conF_01 import * def read_AllSheet_excel(): dfe= pd.read_excel(read_file+'.xlsx', sheet_name=None) rtn_df = concat(dfe) return rtn_df def read_excel(): rtn_df= pd.read_excel(read_file+'.xlsx', sheet_name=0) return rtn_df def write_csv(dfd): # dfd = dfd.to_csv(write_file+'.csv') dfd = dfd.to_csv(write_file+'.csv', encodin..