from pandas_ods_reader import read_ods
import pandas as pd
import os
import sys

pd.options.mode.chained_assignment = None

input_path = sys.argv[1]
output_file_name = os.path.basename(input_path).replace(".ods", ".csv")
output_dir_path = os.path.dirname(input_path)
output_path = output_dir_path + "\\" + output_file_name

df = read_ods(input_path, 1, headers=True)

try:
    df_required_column = df[["Id","Name","Number"]]
except KeyError:
    df["Number"] = ""
    df_required_column = df[["Id","Name","Number"]]

df_required_column.drop_duplicates(keep='last', inplace=True)
df_required_column.to_csv(output_path, encoding='utf-8', index=False)

print (output_path)