아미(아름다운미소)

import pandas as pd# 예시 데이터프레임 생성data = { 'A': [1, 2, 'three', 4], 'B': [True, False, 7.2, 'eight'], 'C': [9, 10, 11, 12]}df = pd.DataFrame(data)# 데이터 타입 확인print("데이터 타입:")print(df.dtypes)# 타입이 다른 행 찾기non_string_A = df[~df['A'].apply(lambda x: isinstance(x, str))]non_int_C = df[~df['C'].apply(lambda x: isinstance(x, int))]non_bool_B = df[~df['B'].apply(lambda x: isinstance(x, bool))]pri..

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가 자동으로 적용됩니다.