4) mergecsv.py

# merge the data from android and ios
import csv
import glob
import pandas as pd
import matplotlib.pyplot as plt
import numpy as np
from datetime import date, timedelta, datetime
from pylab import scatter, show, title, xlabel, ylabel, plot, contour
import re
import os, time
import datetime
from collections import defaultdict
#import itertoolsdcfnbh
import math

import numpy


############## This script merges android and ios files from mapgpsdata script.
a = pd.read_csv("matchedgps_androidcheck.csv",low_memory=False)
b = pd.read_csv("matchedgps_ioscheck.csv",low_memory=False)
#b.columns=["Userid", "BSSID", "Longitude", "Latitude", "wifi_senseStartTimeMillis","gps_senseStartTimeMillis"]
#b = b.dropna(axis=1)
#merged = a.merge(b, on='title')
merged = pd.concat([a,b])
merged.to_csv("mergedbssid_final.csv", index=False)   # final merged file.