Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
learning Python + SQL
#1
Started learning Python + SQL.
Experience 0 = ((
There is a TXT file local. How can I make requests in it? How to import TXT into SQL?
Reply
#2
You give us very little information. Not knowing what the text file looks like,
the first reaction would be that in order to make requests, you don't need sql.
Simple string operations can do a lot.

paul
It is more important to do the right thing, than to do the thing right.(P.Drucker)
Better is the enemy of good. (Montesquieu) = French version for 'kiss'.
Reply
#3
id |color |number |deleted|year|
-----|-----------|------------|-------|----|
21542|black |В 031 ВХ 138|true |2014|
15694|black |С053КН163 |true |2014|

in the task it is precisely necessary to use SQL queries for data selection.[Image: 4a7a3c32c76215dd8ffdec8025ae1ac5-full.png]
Reply
#4
I would read the data using Pandas, and either do the manipulations there or then loop through the Pandas dataframe and post the records into the database. Using the Pandas function read_csv with sep set to '|' and setting header should give you a start.

When you say it is necessary to use SQL, is this homework? Or are you needing the save the data for long term?
Reply
#5
I need to upload data from. txt to sql base and make sql queries
Reply
#6
OK, I explained how I would do it.

Knowing why can be helpful as we try to help you. There may be methods you hadn't thought of. If this is homework where you have been told this must be done with SQL then that's different.
Reply
#7
insert into cars
(id, color, number, deleted, year)
values
(21542, 'black', 'В 031 ВХ 138', 'true', 2014);
... and so on.
Reply


Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020