Before Donald Trump took office, optimism about his presidency was the lowest of any president-elect since at least the 1970s.