# CrossCompute
target_folder = '/tmp'
movie_select_path = 'movies.txt'
# Load table
import pandas as pd
t = pd.read_csv('Interactive_Map_Data.csv', encoding='latin-1', skiprows=1)
# Have user pick a movie
# Filter the table by the movie name
movie_name = open(movie_select_path, 'rt').read().splitlines()[0]
selected_t = t[t['Film'] == movie_name]
# Show map
from os.path import join
target_path = join(target_folder, 'map.csv')
selected_t.to_csv(target_path, index=False)
print('x_geotable_path = %s' % target_path)