import pandas as pd
import re
df1 = {'IDNumber': ['1', '2', '3'], 'Title': ["Vauxhall Astra Model H 92-93", "VW Golf MK2 GTI 90-91", "BMW 1 Series 89-93"]}
df2 = {'Manufacturer': ["VW", "VW", "VW", "Vauxhall", "BMW", "BMW"], 'Model': ["Golf", "Golf", "Golf", "Astra", "2 Series", "1 Series"], 'Type': ['MK2', 'MK2 GTI', 'MK2', 'Model H', '', ''], 'Year': ["1990|1991|1993", "1990|1991|1993", "1896|1897|1898|1899", "1991|1992|1993|1994", "2000|2001|2002", "1889|1890|1891|1892|1893"], 'Tag': ['1000', '1001', '1002', '1003', '1004', '1005']}
# split title of df1 into string and year tag min and year tag max
regular_expression = re.compile(r'\d\d-\d\d')
title_string = df1['*Title']
year_min = title_string.apply(lambda x: regular_expression.search(x)[0].split('-')[0])
year_max = df1['*Title'].apply(lambda x: regular_expression.search(x)[0].split('-')[1])
print(year_min)
aW1wb3J0IHBhbmRhcyBhcyBwZAppbXBvcnQgcmUKCgpkZjEgPSB7J0lETnVtYmVyJzogWycxJywgJzInLCAnMyddLCAnVGl0bGUnOiBbIlZhdXhoYWxsIEFzdHJhIE1vZGVsIEggOTItOTMiLCAiVlcgR29sZiBNSzIgR1RJIDkwLTkxIiwgIkJNVyAxIFNlcmllcyA4OS05MyJdfQpkZjIgPSB7J01hbnVmYWN0dXJlcic6IFsiVlciLCAiVlciLCAiVlciLCAiVmF1eGhhbGwiLCAiQk1XIiwgIkJNVyJdLCAnTW9kZWwnOiBbIkdvbGYiLCAiR29sZiIsICJHb2xmIiwgIkFzdHJhIiwgIjIgU2VyaWVzIiwgIjEgU2VyaWVzIl0sICdUeXBlJzogWydNSzInLCAnTUsyIEdUSScsICdNSzInLCAnTW9kZWwgSCcsICcnLCAnJ10sICdZZWFyJzogWyIxOTkwfDE5OTF8MTk5MyIsICIxOTkwfDE5OTF8MTk5MyIsICIxODk2fDE4OTd8MTg5OHwxODk5IiwgIjE5OTF8MTk5MnwxOTkzfDE5OTQiLCAiMjAwMHwyMDAxfDIwMDIiLCAiMTg4OXwxODkwfDE4OTF8MTg5MnwxODkzIl0sICdUYWcnOiBbJzEwMDAnLCAnMTAwMScsICcxMDAyJywgJzEwMDMnLCAnMTAwNCcsICcxMDA1J119CgoKIyBzcGxpdCB0aXRsZSBvZiBkZjEgaW50byBzdHJpbmcgYW5kIHllYXIgdGFnIG1pbiBhbmQgeWVhciB0YWcgbWF4CnJlZ3VsYXJfZXhwcmVzc2lvbiA9IHJlLmNvbXBpbGUocidcZFxkLVxkXGQnKQoKdGl0bGVfc3RyaW5nID0gZGYxWycqVGl0bGUnXQoKCnllYXJfbWluID0gdGl0bGVfc3RyaW5nLmFwcGx5KGxhbWJkYSB4OiByZWd1bGFyX2V4cHJlc3Npb24uc2VhcmNoKHgpWzBdLnNwbGl0KCctJylbMF0pCgp5ZWFyX21heCA9IGRmMVsnKlRpdGxlJ10uYXBwbHkobGFtYmRhIHg6IHJlZ3VsYXJfZXhwcmVzc2lvbi5zZWFyY2goeClbMF0uc3BsaXQoJy0nKVsxXSkKCnByaW50KHllYXJfbWluKQ==