remove duplicates in python

Question

I'm looking to remove the names that are repeated.

My code is connected to retrieve information from SQL server to Python.

def get_all_artist():
    query="SELECT artist_name FROM Sheet1"
    all_artist = execute_read_query (conn, query)
    for artist_record in all_artist:
        print(str(artist_record[0]))
    return (all_artist)

The artist_name that I am retrieving on SQL are:

BTS
BTS
BTS
TWICE
TWICE
TWICE
TWICE
TWICE
HEIZE
HEIZE
KHALID
KHALID
KHALID
ERIC CHOU
ERIC CHOU
ERIC CHOU
SAM SMITH
SAM SMITH
SAM SMITH
AGUST D

However, I'd only like to remove the duplicates on Python without removing any rows in my SQL table:

BTS
TWICE
HEIZE
KHALID
ERIC CHOU
SAM SMITH
AGUST D

update your SQL query like: "SELECT UNIQUE artist_name FROM Sheet1" — sahinakkaya
– sahinakkaya, Commented Jun 2, 2020 at 9:49

Md Sabbir Hossain · Accepted Answer · 2020-06-02 09:53:03Z

1

Use This Function and It Will Be work:

def get_all_artist():
    query="SELECT distinct artist_name FROM Sheet1"
    all_artist = execute_read_query (conn, query)
    for artist_record in all_artist:
        print(str(artist_record[0]))
    return (all_artist)

answered Jun 2, 2020 at 9:53

Md Sabbir Hossain

2001 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

GMB · Accepted Answer · 2020-06-02 09:49:09Z

0

Use distinct:

select distinct artist_name from sheet1

answered Jun 2, 2020 at 9:49

GMB

224k25 gold badges103 silver badges151 bronze badges

Comments

M-Pixel · Accepted Answer · 2020-06-02 17:00:13Z

0

Assuming this is a SQL query, the statement for removing repetition is DISTINCT:

query="SELECT DISTINCT artist_name FROM Sheet1"

edited Jun 2, 2020 at 17:00

M-Pixel

3,5852 gold badges18 silver badges31 bronze badges

answered Jun 2, 2020 at 9:49

Vijay

12215 bronze badges

Collectives™ on Stack Overflow

remove duplicates in python

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related