python - Extract distinct values from Dataframe and insert them into new Dataframe with same column Name

Question

Using python 3.7 , pandas 1.1.3 , Anaconda Jupyter Notebook

I am new into python and I have a following dataframe.

DF_1

Name  Date
AAA   2000-09-01
BBB   2001-08-01
CCC   2002-07-01
AAA   2005-05-01

I just want to extract distinct values from 'Name' column and create a new dataframe (df_2) and insert into it with same column name.

Output df_2 should look like this

Name
AAA
BBB
CCC

question from:https://stackoverflow.com/questions/65913796/extract-distinct-values-from-dataframe-and-insert-them-into-new-dataframe-with-s

Answer 1

Try this:

df_2 = DF_1[['Name']].drop_duplicates()