Allow add_categories() to accept Series/np.array and make raising on dup...
...licates optional, fixes #9927

@mortada ok, for now pls take out the `raise_on_duplicates` kw and leave the rest.
 @jreback  it's updated 
 @mortada thanks!
