All Questions
5 questions
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 ...
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 ...
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
...
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 ...