title: Importing data from SQLite to python using pandas?
body: <p>I've just downloaded some data and it is named 'database.sqlite'.</p>
  
  <p>Now, I am trying to import the data in this database to a data frame using Pandas. My code is below: </p>
  
  <pre><code>import sqlite3
  import pandas
  
  conn = sqlite3.connect('database.sqlite')
  df = pd.read_sql_query("select * from country", conn)
  </code></pre>
  
  <p>But I keep getting the following error:</p>
  
  <pre><code>DatabaseError: Execution failed on sql 'select * from country': no such table: country
  
  </code></pre>
  
  <p>But I know that there is a table named 'country' as I am viewing the database on DB Browser for SQLite.</p>
  
  <p>Why am I getting this error?</p>