{"metadata":{"kernelspec":{"language":"python","display_name":"Python 3","name":"python3"},"language_info":{"pygments_lexer":"ipython3","nbconvert_exporter":"python","version":"3.6.4","file_extension":".py","codemirror_mode":{"name":"ipython","version":3},"name":"python","mimetype":"text/x-python"}},"nbformat_minor":4,"nbformat":4,"cells":[{"cell_type":"markdown","source":"Here is a quick fix for the missing data column names in the nyra_2019_start data file and nyra_2019_complete data files.","metadata":{}},{"cell_type":"code","source":"import pandas as pd\n\nstart_columns = ['track_id','race_date','race_number','program_number','weight_carried','jockey','odds','position_at_finish']\nstart = pd.read_csv('/kaggle/input/big-data-derby-2022/nyra_start_table.csv',names=start_columns)\n\ncomplete_columns = ['track_id','race_date','race_number','program_number','trakus_index','latitude','longitude','distance_id','course_type','track_condition','run_up_distance','race_type','purse','post_time','weight_carried','jockey','odds','position_at_finish']\ncomplete = pd.read_csv('/kaggle/input/big-data-derby-2022/nyra_2019_complete.csv',names=complete_columns)\n","metadata":{"execution":{"iopub.status.busy":"2022-09-11T18:45:41.995391Z","iopub.execute_input":"2022-09-11T18:45:41.995848Z","iopub.status.idle":"2022-09-11T18:45:51.293433Z","shell.execute_reply.started":"2022-09-11T18:45:41.995814Z","shell.execute_reply":"2022-09-11T18:45:51.292230Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"start","metadata":{"execution":{"iopub.status.busy":"2022-09-11T18:45:51.297900Z","iopub.execute_input":"2022-09-11T18:45:51.298273Z","iopub.status.idle":"2022-09-11T18:45:51.318300Z","shell.execute_reply.started":"2022-09-11T18:45:51.298242Z","shell.execute_reply":"2022-09-11T18:45:51.317129Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"complete","metadata":{"execution":{"iopub.status.busy":"2022-09-11T18:45:51.319491Z","iopub.execute_input":"2022-09-11T18:45:51.319932Z","iopub.status.idle":"2022-09-11T18:45:51.354930Z","shell.execute_reply.started":"2022-09-11T18:45:51.319874Z","shell.execute_reply":"2022-09-11T18:45:51.353429Z"},"trusted":true},"execution_count":null,"outputs":[]}]}