i want to remove sqaure brackets from python list output

Question

 df = pd.read_excel('Websites.xlsx', usecols=[3])
 webs = df.dropna()
 weblist = webs.values.tolist()
 for count in range(0,len(weblist)):
     print (weblist[count])

the output is

['TRIPADVISOR.COM']
['CHASE.COM']
['WEBMD.COM']
['WEATHER.COM']
['INDEED.COM']
['HOMEDEPOT.COM']
['CRAIGSLIST.ORG']
['BANKOFAMERICA.COM']

i need to convert this all to website format like https://www.example.com

You have a list of lists, you need to access the element of the list rather print the list, you should be able to figure this out — EdChum, Mar 18 '20 at 12:44
Does this answer your question? [How to print each element of a list of lists in python using the specific elements](https://stackoverflow.com/questions/46875511/how-to-print-each-element-of-a-list-of-lists-in-python-using-the-specific-elemen) — Jared Smith, Mar 18 '20 at 12:45

score 2 · Accepted Answer · answered Mar 18 '20 at 12:45

2

I think output is one column Dataframe, so add DataFrame.squeeze for Series, last loop and change url with f-strings:

for i in webs.squeeze():
 print (f'https://www.{i.lower()}')

answered Mar 18 '20 at 12:45

jezrael

822,522
95
1,334
1,252

GLarose · Answer 2 · 2020-03-18T13:06:18.167

If I understand what you are intending to do, try flattening list of lists:

flat_weblist = [i for lst in weblist for i in lst]

 ['TRIPADVISOR.COM',
  'CHASE.COM',
  'WEBMD.COM',
  'WEATHER.COM',
  'INDEED.COM',
  'HOMEDEPOT.COM',
  'CRAIGSLIST.ORG',
  'BANKOFAMERICA.COM']

Then joining string:

http_list = [''.join(('http://www', i.lower()) for i in flat_weblist]

['http://tripadvisor.com',
 'http://chase.com',
 'http://webmd.com',
 'http://weather.com',
 'http://indeed.com',
 'http://homedepot.com',
 'http://craigslist.org',
 'http://bankofamerica.com']

i want to remove sqaure brackets from python list output

2 Answers2