order.append( 1000) #These are hardcoded values for trader id and algorithm id. order.append( 1000) #I may have more traders/algorithms but not for a while. order.append(random.choice(tickers)) order.append(random.choice(order_type)) order.append(randrange(100, 400)) # Price targets will be off order.append(random.choice(size)) order.append(random.choice(date_range)) order.append(random.choice(time_range)) data.append(order) return data if __name__ == "__main__": crud = CRUD() n = len(sys.argv) if n >= 3: file_name = sys.argv[1] total = sys.argv[2] else: print("PASS IN ARGUMENTS!") exit(0) data = generateOrders(int(total)) df = pd.DataFrame.from_records(data, columns=columns) # CONVERT TO DF #df.to_csv(file_name, index=False) # I'm leaving this in to show I can do it crud.insertTrade(df) #I export straight to my db