vscode에서 파일을 찾을 수 없다고 뜨는데 파일이 경로에는 있습니다.

Question

#librayimport streamlit as stimport pandas as pdimport xmltodictimport requestsimport jsonimport openpyxlfrom datetime import datetime #엑셀파일df &#61; pd.read_excel('data.xlsx',engine&#61;'openpyxl') #사용자 선택지 제공values_1st &#61; df['1단계'].unique().tolist()selected_1st &#61; st.selectbox('1단계를 선택하세요', values_1st)values_2nd &#61; df[df['1단계'] &#61;&#61; selected_1st]['2단계'].unique().tolist()selected_2nd &#61; st.selectbox('2단계를 선택하세요', values_2nd)values_3rd &#61; df[(df['1단계'] &#61;&#61; selected_1st) & (df['2단계'] &#61;&#61; selected_2nd)]['3단계'].unique().tolist()selected_3rd &#61; st.selectbox('3단계를 선택하세요', values_3rd) filtered_df &#61; df[(df['1단계'] &#61;&#61; selected_1st) & (df['2단계'] &#61;&#61; selected_2nd) & (df['3단계'] &#61;&#61; selected_3rd)]st.write(filtered_df[['격자 X', '격자 Y']]) #날씨 조회 APIif not filtered_df.empty: x_value &#61; filtered_df['격자 X'].values[0] y_value &#61; filtered_df['격자 Y'].values[0] now &#61; datetime.now().date() tonow &#61; str(now).replace('-','') url &#61; 'http://apis.data.go.kr/1360000/VilageFcstInfoService_2.0/getVilageFcst' params &#61;{'serviceKey' : 'PkwihJpgw42AG85zGPmSye6E7wMAitUOt6ok69xncCrg3HPn9sdwLlNMjH&#43;OO2tzoUI04&#43;3cv7xy7gNKCcXqvQ&#61;&#61;', 'pageNo' : '1', 'numOfRows' : '1000', 'dataType' : 'XML', 'base_date' : tonow, 'base_time' : '0500', 'nx' : x_value, 'ny' : y_value } response &#61; requests.get(url, params&#61;params) xmlData &#61; response.text json_data &#61; json.dumps(xmltodict.parse(xmlData), indent&#61;4) dict &#61; json.loads(json_data) result&#61; [] for item in dict[&#34;response&#34;][&#34;body&#34;][&#34;items&#34;][&#34;item&#34;]: if item[&#34;category&#34;] !&#61; &#34;TMP&#34;: continue result.append({ &#34;날짜&#34; : item[&#34;fcstDate&#34;][:4] &#43; &#34;년&#34; &#43; item[&#34;fcstDate&#34;][4:6] &#43; &#34;월&#34; &#43; item[&#34;fcstDate&#34;][6:] &#43; &#34;일&#34;, &#34;시간대&#34; : item[&#34;fcstTime&#34;][:2]&#43;&#34;:&#34;&#43;item[&#34;fcstTime&#34;][2:], &#34;기온&#34; : item[&#34;fcstValue&#34;]&#43;&#34;℃&#34; }) st.write(&#34;전체예보&#34;) df &#61; pd.DataFrame(result) st.table(df)

allinux · Answer

엑셀파일 경로를 "절대경로"로 넣어보세요.

vscode에서 파일을 찾을 수 없다고 뜨는데 파일이 경로에는 있습니다.

1개의 답변

Q&A 목록