Analyze some Data

I want to analyze some trajectory data using Python 2.7 programming language and visualize the results using D3.js. The data are stored in sqlite databases. First I would like you to correct an [login to view URL] in a already written script to filter the data before starting the analysis. Then you must write scripts to: - Match a series of coordinates to some areas (the boundary of the areas will be provided). In which one of the given areas does the starting and finishing point of the route fall in and store the corresponding numbers of the areas (start - finish) in the DB. - Find common routes (same starting and finishing area e.g area1 -> area 2) - Compute the propability of finding a client (start of the route) for each area. Characterize as high propability area the areas with greater propability than the average propability. - Compute the average duration (minutes) of the routes. - Find areas with high propability of finding a client (start of the route) with high duration route (greater than the average route duration). - Compute the demand per weekday (number of trips per day) and periods of the day. (Each route has a starting and finishing timestamp.) - Compute the nearest (in means of distance) high propability area after the finish of a route. - Find the routes that have a number of passengers greater than 4 per starting area. - Visualize the results using JavaScript library D3.js. For more details - questions PM