以下のファイルを通したい。
pathをどうコードを書けば、エラー無く実行されるのかわからないで、コードの書き方をご教授お願い致します。
OS---macOS Catalina
ver10.15.5
python
1for i in company_name: 2 df_order_company = df_order[df_order['会社名'] == i] 3 df_order_company.to_excel(export_file_path+'/'+i+'.xlsx') 4 5エラー内容 6NameError Traceback (most recent call last) 7<ipython-input-15-f02548b0d5b0> in <module> 8 1 for i in company_name: 9 2 df_order_company = df_order[df_order['会社名'] == i] 10----> 3 df_order_company.to_excel(export_file_path+'/'+i+'.xlsx') 11 12NameError: name 'export_file_path' is not defined 13 14追記 15for i in company_name: 16 df_order_company = df_order[df_order['会社名'] == i] 17 export_file_path= company_name:'/Users/??/Desktop/MyPython/sample-1.xlsx' 18 df_order_company.to_excel(export_file_path+'/'+i+'.xlsx') 19 20エラー 21File "<ipython-input-1-778b39ef22ea>", line 3 22 export_file_path= company_name:'/Users/??/Desktop/MyPython/sample-1.xlsx' 23 ^ 24SyntaxError: invalid character in identifier 25 26 27 28 29’’’’export_file_path = '/Users/??/Desktop/MyPython 30 31’’’’for i in company_name: 32df_order_company = df_order[df_order['会社名'] == i] 33df_order_company.to_excel(export_file_path+'/'+i+'.xlsx') 34↓ 35 File "<ipython-input-29-58f4cd063e9b>", line 2 36 df_order_company = df_order[df_order['会社名'] == i] 37 ^ 38IndentationError: expected an indented block 39 40 41 42
回答1件
あなたの回答
tips
プレビュー