codellama

/

CodeLlama-70b-hf

like 309

请帮我写一段python 读取excel 程序 excel 在某个目录下 子目录下面也有文件 xlsx 请用pyopenxl

@Eric1104 use pandas, or langchain.document_loaders.unstructured or llamaIndex. Tons of options available

The code output of Llama based models screw up Python indentation so bad that the code neither works nor can be fixed by auto formatters. Only manual fix can make the code work again. Anyone else noticed this?
Take a look at this simple python code it generated yesterday, The lines after "def:", "except:" and last "if:" have only 1 space characer. Also, "if:" and "elif": have different margins, all of these make the code buggy and unfixable. There are cases with 1,2,3,4 spaces!

import sys,base64
def main():
 try:
     if len(sys.argv)>=3:
         opcode = str(sys.argv[1]) #operation code
         data = str(sys.argv[2]) #data
         
         if opcode == "enc":
             encoded_string = base64.b64encode(bytes(data,"utf8"))
             result = f"Encoded String:\n{encoded_string}"
             
         elif opcode == "dec":
            decoded_string = base64.b64decode(str(data))
            result = f"Decoded String:\n {decoded_string}"
        else:
           raise Exception("Invalid Operation Code")
      except IndexError:
       print('Please provide two arguments')
      except ValueError:
       print('Please enter valid input')
      except Exception as e:
       print(f'An error occurred: {e}')
if __name__== '__main__':
 main()