03 - code_to_make_big_file.py
# -*- coding: utf-8 -*-
"""
Created on Wed Nov 4 12:44:49 2020
Code to make a single large dataframe with all approaches for all fish.
@author: Rachel
"""
#------ getting set up ---------------#
import os
import pandas as pd
import pyproj
import numpy as np
import shapefile
#import matplotlib.pyplot as plt
proj_directory = os.getcwd()
#%%
from shapely.geometry import shape, Point
#%% code to make large file
input_folder= (proj_directory+'\\data\\data near ladder NEW 60mins\\')
input_files = os.listdir(input_folder)
large_file = pd.DataFrame()
for i in input_files:
data = pd.read_csv(input_folder+i,index_col='Time', parse_dates=['Time'])
large_file = pd.concat([large_file,data])
#%% save large file
large_file.to_csv(proj_directory+'\\data\\all_approaches_60mins.csv')
#%%