I have a dataframe with a column that contains tuples. I would like to create a new column that extracts the smallest tuple from the tuple column.
What I have tried so far
mydataframe['min_values'] = mydataframe['tuple_column'].apply(lambda x: min(x))
This above approach seems to work when I have at least 2 tuples, but it fails when I only have one tuple e.g. 5 in the example below. Could you guys please suggest a method that would help me accomplish this task in a better manner?
Example and desired result
|Tuple Column||New Column|
(5) is not a tuple, this is
numpy.min that handles scalar values as input:
import numpy as np df['New Column'] = df['Tuple Column'].apply(np.min)
Tuple Column New Column 0 (1, 2, 3, 5) 1 1 (10, 11) 10 2 5 5