아미(아름다운미소)

sql case whenSELECT 이름, 성적, 출석률, CASE WHEN 성적 >= 90 AND 출석률 >= 90 THEN 'A' WHEN 성적 >= 80 AND 출석률 >= 80 THEN 'B' WHEN 성적 >= 70 AND 출석률 >= 70 THEN 'C' WHEN 성적 >= 60 AND 출석률 >= 60 THEN 'D' ELSE 'F' END AS 등급FROM 학생;np.whereimport pandas as pdimport numpy as np# 샘플 DataFrame 생성data = { '이름': ['학생1', '학생2', '학생3', '학생4', '학생..

import pandas as pddef fn_df(dict_df_types, df) -> pd.DataFrame: list_int = [k_ for (k_, v_) in dict_df_types.items() if (v_ != 'string') and (v_ != 'boolean') and (k_ in df.columns.to_list())] list_str = [k_ for (k_, v_) in dict_df_types.items() if (v_ == 'string') and (k_ in df.columns.to_list())] list_bool = [k_ for (k_, v_) in dict_df_types.items() if (v_ == 'boolean') and (k_ in df..

rm -Rf /Applications/Android\ Studio.apprm -Rf ~/Library/Preferences/AndroidStudio*rm -Rf ~/Library/Preferences/com.google.android.*rm -Rf ~/Library/Preferences/com.android.*rm -Rf ~/Library/Application\ Support/AndroidStudio*rm -Rf ~/Library/Logs/AndroidStudio*rm -Rf ~/Library/Caches/AndroidStudio*rm -Rf ~/.AndroidStudio*rm -Rf ~/Library/Application\ Support/Google/AndroidStudio*https://stackov..

source ~/.bashrc 시 내용이 적용이 안될 경우예를 들어, ~/.bash_profile 파일에 다음 줄을 추가할 수 있습니다:if [ -f ~/.bashrc ]; then source ~/.bashrcfi이렇게 설정하면 로그인할 때마다 .bashrc가 자동으로 적용됩니다.