How do you create a pivot table group by Date and perfom calculation on 2 values in pandas

I have this data frame:

Finding offending entries when pivot fails with a ValueError: Index contains duplicate entries, cannot reshape

I have a dataframe with 3 columns and datatypes: Datetime (Datetime dtype), Area (string), Value (float).