All Questions
9 questions
3
votes
1
answer
115
views
Flask Database Design with ORM
I am designing a Stock Currency application and for that, I created a database.
I searched for my question here first but the answerer told me to ask the same question here.
...
- 141
3
votes
1
answer
69
views
Python script to find employees who are in one PostgreSQL table but not in another
I'm writing a python script and do database query to get the ids of employees who are in one table but are not in another. I'm using psycopg2 module for python 2 and PostgreSQL as database. After ...
- 433
2
votes
1
answer
2k
views
Conditional joining Pandas dataframes
I'm looking for an optimum way to join two Dataframes where the same record exists in both. Examples would be:
...
- 43
7
votes
3
answers
251
views
Linking two databases based on street addresses
For my work, I wrote a python script to link 2 files. Since I am an autodidact and since no one of my colleagues writes code, I ask the question here.
My code takes an unbelievable time to run. Is it ...
- 191
5
votes
2
answers
124
views
Matching maximal nodes with velocities
I have written a code which works very good for small data-files (see below). The data file 'WSPL.dat' which I want to evaluate has a size of 2.6 GB and the data file 'VELOC.dat' has a size of 4.3 GB....
6
votes
1
answer
8k
views
Python search for array in large text file
I asked similar question at: https://stackoverflow.com/questions/38410982/superfast-regexmatch-in-large-text-file
...
- 499
3
votes
1
answer
112
views
Filling in gym membership prices by joining PANDAS dataframes
I have two dataframes, df which contains a list of members in addition to the type of contract that they purchased on a given date, ...
8
votes
2
answers
143
views
Iterate list to map entries in Python
I have two files, namely:
File1:
CL1 AA XX YY ZZ SS \n
CL2 3_b AA
File2:
AA string1
AA string2
3_b string3
My ...
- 201
3
votes
1
answer
122
views
Scanning multiple huge files in Python (follow-up)
I'm trying to implement an algorithm able to search for multiple keys through ten huge files in Python (16 million of rows each one). I've got a sorted file with 62 million of keys, and I'm trying to ...
- 233