title: how to remove part of a dictionaries that are in a list
body: <p>I web scraped a website and inputted the data into an sql3 database. For some reason, there's this black star in front of each name that's not an asterisk. It's one character that goes in front of the name, and I don't want to go in each row of data and erase it by hand because that's tedious, plus when I update the data on the table, the stars are just gonna come back. Does anyone know how to remove the star before it goes into the table? the data I extracted is a list with dictionaries as the elements. Thank you in advance!</p>
  <pre><code>import requests
  from bs4 import BeautifulSoup
  import byebyebirdie
  import json
  ##from  tkinter import *
  ##bobert=Tk()
  ##bobert.geometry(&quot;600x600&quot;)
  import sqlite3
  
  
  connection = sqlite3.connect('covidproject.db')
  cursor = connection.cursor()
  
  ##cursor.execute(&quot;DROP TABLE IF EXISTS covid &quot;)
  
  ##cursor.execute(&quot;CREATE TABLE IF NOT EXISTS covid (name STRING, confirmed REAL, changes_today REAL,deceased REAL,active REAL, recovered REAL)&quot;)
  
  url = 'https://ncov2019.live/'
  headers = {'User-Agent':'Mozilla/5.0'}
  response = requests.get(url, headers = headers)
  response.status_code
  
  soup = BeautifulSoup(response.content,'html.parser')
  stat_table = soup.find_all(&quot;table&quot;, attrs={&quot;class&quot;: &quot;display responsive&quot;})
  
  headers = [header.get_text(strip=True) for header in soup.find_all(&quot;th&quot;)]
  rows = [dict(zip(headers, [td.get_text(strip=True) for td in row.find_all(&quot;td&quot;)]))
          for row in soup.find_all(&quot;tr&quot;)[1:-1]]
  
  print(&quot;e&quot;)
  i=9
  ##while 8&lt;i&lt;223:
  ##    print(&quot;h&quot;)
  ##    roa=rows[i]['Name']
  ##    rob=rows[i]['Confirmed']
  ##    roc=rows[i]['Changes Today']
  ##    rod=rows[i]['Deceased']
  ##    roe=rows[i]['Active']
  ##    rof=rows[i]['Recovered']
  ##    cursor.execute(&quot;INSERT INTO covid VALUES('&quot;+roa+&quot;','&quot;+rob+&quot;','&quot;+roc+&quot;','&quot;+rod+&quot;','&quot;+roe+&quot;','&quot;+rof+&quot;')&quot;)
  ##    connection.commit()
  ##    i=i+1
      
  print (json.dumps(rows[9], indent=2))
  print (rows[222]['Name'])
  </code></pre>
  <p>The dictionaries in the list look like this</p>
  <pre><code>{
    &quot;Name&quot;: &quot;\u2605Hong Kong&quot;,
    &quot;Confirmed&quot;: &quot;1,714&quot;,
    &quot;Changes Today&quot;: &quot;0&quot;,
    &quot;Percentage Day Change&quot;: &quot;0%&quot;,
    &quot;Critical&quot;: &quot;8&quot;,
    &quot;Deceased&quot;: &quot;11&quot;,
    &quot;Percentage Death Change&quot;: &quot;0%&quot;,
    &quot;Tests&quot;: &quot;442,256&quot;,
    &quot;Active&quot;: &quot;439&quot;,
    &quot;Recovered&quot;: &quot;1,264&quot;
  }
  </code></pre>
  <p>and in sqlite3 the name would look like this:★Albania</p>