In [2]:

    

import pandas as pd
import numpy as np


    

In [19]:

    

#Read Csv files
df_1_500001 = pd.read_csv("../data/transactions-1-500001.csv")
df_500001_1000000 = pd.read_csv("../data/transactions-500001-1000000.csv")
df_1000000_1000001 = pd.read_csv("../data/transactions-1000000-1000001.csv")
df_1000001_1300000 = pd.read_csv("../data/transactions-1000001-1300000.csv")
df_1300000_1300001 = pd.read_csv("../data/transactions-1300000-1300001.csv")
df_1300001_1500001 = pd.read_csv("../data/transactions-1300001-1500001.csv")
df_1500001_1700000 = pd.read_csv("../data/transactions-1500001-1700000.csv")
df_1700000_1700001 = pd.read_csv("../data/transactions-1700000-1700001.csv")
df_1700001_1900000 = pd.read_csv("../data/transactions-1700001-1900000.csv")
df_1900000_1900001 = pd.read_csv("../data/transactions-1900000-1900001.csv")
df_1900001_2100000 = pd.read_csv("../data/transactions-1900001-2100000.csv")
df_2100000_2100001 = pd.read_csv("../data/transactions-2100000-2100001.csv")
df_2100001_2184224 = pd.read_csv("../data/transactions-2100001-2184224.csv")

#Concatenate dataframe
df = pd.concat([df_1_500001,
                df_500001_1000000,
                df_1000000_1000001,
                df_1000001_1300000,
                df_1300000_1300001,
                df_1300001_1500001,
                df_1500001_1700000,
                df_1700000_1700001,
                df_1700001_1900000,
                df_1900000_1900001,
                df_1900001_2100000,
                df_2100000_2100001,
                df_2100001_2184224
               ])


    

In [24]:

    

df.to_csv("../data/transactions-1-2184224.csv")