Forgot Password,

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account?

You must login to ask a question.

Need An Account,

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Search
Ask A Question
Leave An Answer!
Home/ Questions/Q 112421
Next
In Process

databaseanswers.net Latest Questions

  • 1
Clara
Beginner
Asked: 2018-12-15T19:33:20-05:00

How to load information in two columns?

Question 1: The file phone.txt stores the lines in the format code:number

enter image description here

import pandas as pd
import sqlite3

con = sqlite3.connect('database.db')
data = pd.read_csv('phone.txt', sep='\t', header=None)
data.to_sql('post_table', con, if_exists='replace', index=False)

I want to load all the data from the phone.txt file into the database.db database. But I have everything loaded in one column. And I need to load in two columns:

  1. code
  2. number

How to do it?

Question 2: after downloading the information to the database, how can I find the number by code? For example, if I want to find out what number code = 7 (answer: 9062621390).

pandaspython-3.xsqlite

Related Questions

Leave an answer

You must login to add an answer.

Need An Account,

1 Answer

Voted Oldest Recent Random
  1. ayorgo

    Question 1

    In your example pandas is not able to distinguish between the code and the number since your file is :-separated. When reading your file you need to change the separator to : and also specify columns since your csv doesn’t seem to have a header like so

    data = pd.read_csv('phone.txt',
                   sep=':',
                   names=['code', 'number'])

    Question 2

    After putting your data to the database you can query it as follows

    number = pd.read_sql_query('SELECT number FROM post_table WHERE code = (?)',
                           con,
                           params=(code,))

    where con is your sqlite connection.

    • 1