What does a little over 80k/yr get you?

I am not sure if a post like this is allowed, I apologize in advance if it is. I am in the process of hiring a Data Analyst position. We have a little over 80k budgeted in a low COL city in the Midwest. What can 80k get me skills/experience wise?

Is that considered entry level 1-2 year experience? Or more? Our team is in analytics but we straddle operations so we don't have anyone else that has expert level knowledge of Python we mostly use SQL/SSIS/SSRS/etc etc. We haven't gotten too many resumes and I wasn't sure what I should be expecting.

Obviously I want to get the most experience I can, but I like hard working people over someone that just has experience on paper. The biggest downside is you can't work/live remote and would have to move to the large mid west town which I know reduces our talent pool.

If people could share either there experience level/salaries and or friends, Coworkers, etc to help me understand if we budgeted too little or too much I would really appreciate it!!

Thanks so much



/r/Python
https://redd.it/6qt0eq

Installing Jupyter Notebook in a dockerized Django project. It helped me a lot in testing and debugging.
http://fsdev.io/how-to-install-jupyter-notebook-in-a-dockerized-django-project/

/r/django
https://redd.it/6qvaj4

Any tips/tricks for debugging factory model in Flask?

Hey r/flask,

Does anyone have any development standards, tips, or tricks for working with the app factory model of Flask development?

I felt like I had a handle on it, and now all of a sudden, it seems like Flask-Mail has no app it knows about even though I feel I init-ed it...what's the best way for me to go about debugging this?

Thanks for your time!

/r/flask
https://redd.it/6qsw1s

Libraries for working with matrices larger than memory

I have a matrix that is 10Mx3k. When loaded in R it is around 100G, and it would probably be the same in numpy or pandas.

I need to do some row-wise operations on this matrix (normalizing, calculating correlation coeffecients), ie. things that actually do not require the whole matrix to be in memory at the same time.

I was considering writing some code for memory mapping that would essentially do lazy loading of the matrix, but i figure somebody already has this or it is somehow supported in numpy. Is this the case? How do you work with very large matrices?

/r/pystats
https://redd.it/6qwy4b

What's everyone working on this week?

Tell /r/python what you're working on this week! You can be bragging, grousing, sharing your passion, or explaining your pain. Talk about your current project or your pet project; whatever you want to share.


/r/Python
https://redd.it/6qwgu1

Installing Jupyter Notebook in a dockerized Django project. It enabled me access to database and code reloading.
http://fsdev.io/how-to-install-jupyter-notebook-in-a-dockerized-django-project/

/r/IPython
https://redd.it/6qx0yl

Allow-file-access-from-files static media serve

As the title reads, I am working on a project and I am trying to have django serve a file but because it's local my javascript is not allowed to access it since it uses the local path rather than the URL.

Does anyone have any suggestions to work around this?

/r/djangolearning
https://redd.it/6qz4ku

My code for Tic-Tac-Toe (beginner), compared to my mate that works at google's code.

Thought it would be interesting seeing someone beginner code, vs someone's professional code on the same project. After I sent him my code he replied with how he would have done it, as a comparison.

**My code:**

import random

def plyr1wintest(): #checks if player has 3 in a row
global winner
if (1 in plyr1list) and (2 in plyr1list) and (3 in plyr1list) or \
(4 in plyr1list) and (5 in plyr1list) and (6 in plyr1list) or \
(7 in plyr1list) and (8 in plyr1list) and (9 in plyr1list) or \
(1 in plyr1list) and (4 in plyr1list) and (7 in plyr1list) or \
(2 in plyr1list) and (5 in plyr1list) and (8 in plyr1list) or \
(3 in plyr1list) and (6 in plyr1list) and (9 in plyr1list) or \
(1 in plyr1list) and (5 in plyr1list) and (9 in plyr1list) or \
(3 in plyr1list) and (5 in plyr1list) and (7 in plyr1list):
print ((name1) + ' wins as X')
winner = True

def plyr2wintest(): #checks if player has three in a row
global winner
if (1 in plyr2list) and (2 in plyr2list) and (3 in plyr2list) or \
(4 in plyr2list) and (5 in plyr2list) and (6 in plyr2list) or \
(7 in plyr2list) and (8 in plyr2list) and (9 in plyr2list) or \
(1 in plyr2list) and (4 in plyr2list) and (7 in plyr2list) or \
(2 in plyr2list) and (5 in plyr2list) and (8 in plyr2list) or \
(3 in plyr2list) and (6 in plyr2list) and (9 in plyr2list) or \
(1 in plyr2list) and (5 in plyr2list) and (9 in plyr2list) or \
(3 in plyr2list) and (5 in plyr2list) and (7 in plyr2list):
print ((name2) + ' wins as O')
winner = True

def printboard(): #print board
print(' ')
print(' '+ position[0] +' | '+ position[1] +' | '+ position[2] + ' ' + ' '+ '1' +' | '+ '2' +' | '+ '3')
print('-----------' + ' ' + '-----------')
print(' '+ position[3] +' | '+ position[4] +' | '+ position[5] + ' ' + ' '+ '4' +' | '+ '5' +' | '+ '6')
print('-----------' + ' ' + '-----------')
print(' '+ position[6] +' | '+ position[7] +' | '+ position[8] + ' ' + ' '+ '7' +' | '+ '8' +' | '+ '9')
print(' ')

winner = False #win checker
movecount = 0 #counts amount of turns
playgame = True

print ('welcome to Noughts & Crosses') #title

while playgame == True:
position = [' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' '] #sets the board spaces blank
plyr1list = []
plyr2list = []
gamelist = []

winner = False
movecount = 0

print (' ')
#Name input
print ('What is player 1s name?')
name1 = input()
print ('thanks '+ (name1) +', Whats player 2s name?')
name2 = input()
print ('so '+ (name1) +' is X and '+ (name2) + ' is O')
input("Press Enter to continue...")

printboard()

while (movecount < 9) and (winner == False):

if (movecount % 2 == 0): #player 1 turn

print ((name1) + 's ( X ) turn, please choose placement (1-9)')
move = input()
if move in ('1', '2', '3', '4', '5', '6', '7', '8', '9') and (int(move) not in (gamelist)):
plyr1list.append(int(move))
gamelist.append(int(move))
print (gamelist) #debug
position[int(move)-1] = ('X')
printboard()
movecount = movecount + 1
plyr1wintest()
elif move not in ('1', '2', '3', '4', '5', '6', '7', '8', '9'):
print ('That is not a valid move! Try again')
else: print ('That move is taken!, Try again')

else: #player 2 turn

print ((name2) + 's ( O ) turn, please choose placement (1-9)')

move = input()
if move in ('1', '2', '3', '4', '5', '6', '7', '8', '9') and (int(move) not in (gamelist)):
plyr2list.append(int(move))
gamelist.append(int(move))
print (gamelist) #debug
position[int(move)-1] = ('O')
printboard()
movecount = movecount + 1
plyr2wintest()
elif move not in ('1', '2', '3', '4', '5', '6', '7', '8', '9'):
print ('That is not a valid move! Try again')
else: print ('That move is taken!, Try again')

#end game
if winner == True:
print ('Congrats!')
else: print ('Its a tie BOI!')
print (' ')

#playagain
answer = 0
valid = False
print ('Would you like to play again (y/n)')
while valid == False: #waits until valid answer is submitted
answer = input()
if answer == 'y':
print ('aight, resetting...')
valid = True
elif answer == 'n':
print ('aight, cya')
print (' ') #ASCII art up in here cause why not
print(' * ,MMM8&&&. *')
print(' MMMM88&&&&& .')
print(' MMMM88&&&&&&&')
print(' * MMM88&&&&&&&&')
print(' MMM88&&&&&&&&')
print(' MMM88&&&&&&')
print(' MMM8&&& *')
print(' |\___/| ')
print(' ) ( . ')
print(' =\ /=')
print(' )===( Thanks for playing *')
print(' / \ ')
print(' | |')
print(' / \ ')
print(' \ / ')
print(' _/\_/\_/\__ _/_/\_/\_/\_/\_/\_/\_/\_/\_/\_ ')
print(' | | | |( ( | | | | | | | | | | ')
print(' | | | | ) ) | | | | | | | | | | ')
print(' | | | |(_( | | | | | | | | | | ')
print(' | | | | | | | | | | | | | | | ')
print(' By Me yay| | | | | | | | | ')
valid = True
playgame = False
else: print ('answer not valid, please use y or n')
#End

**His code:**

#!/usr/bin/python
"""Noughts and Crosses."""

import sys

def Input(*args):
"""Kludge to handle python 2 and 3."""
if sys.version_info.major >= 3:
return input(*args)
return raw_input(*args)

bye = r"""
* ,MMM8&&&. *
MMMM88&&&&& .
MMMM88&&&&&&&
* MMM88&&&&&&&&
MMM88&&&&&&&&
MMM88&&&&&&
MMM8&&& *
|\___/|
) ( .
=\ /=
)===( Thanks for playing *
/ \
| |
/ \
\ /
_/\_/\_/\__ _/_/\_/\_/\_/\_/\_/\_/\_/\_/\_
| | | |( ( | | | | | | | | | |
| | | | ) ) | | | | | | | | | |
| | | |(_( | | | | | | | | | |
| | | | | | | | | | | | | | |
By Me yay | | | | | | | | |
"""


def Play():
"""Play one round of noughts and crosses."""
position = [' ' for _ in range(9)]

print ("What is player 1's name?")
name1 = Input()
print ("Thanks %s, What's player 2's name?" % name1)
name2 = Input()
print ('So %s is X and %s is O.' % (name1, name2))
Input('Press Enter to continue...')

PrintBoard(position)

players = [(name1, 'X'), (name2, 'O')]

for movecount in range(9):
player = players[movecount % 2]
while True:
print ("%s's ( %s ) turn, please choose placement [1-9]?" % player)
try:
move = int(Input())
except ValueError:
print ('Invalid input, please choose placement [1-9]?')
continue
if move < 1 or move > 9:
print ('That is not a valid move! Try again.')
continue
if position[move-1] != ' ':
print ('That move is taken!, Try again.')
continue
break

position[move-1] = player[1]
PrintBoard(position)
if PlayerWin(position, player):
print ('%s wins as %s.' % player)
break
else:
print ('Its a tie BOI!')


def PrintBoard(position):
print ("""
%s | %s | %s 1 | 2 | 3
----------- -----------
%s | %s | %s 4 | 5 | 6
----------- -----------
%s | %s | %s 7 | 8 | 9
""" % tuple(p for p in position))


def PlayerWin(position, player):

def Marks(m1, m2, m3):
return tuple(position[i-1] for i in (m1, m2, m3))

mark = player[1]
win = (mark, mark, mark)
return (
Marks(4, 5, 6) == win or
Marks(7, 8, 9) == win or
Marks(1, 4, 7) == win or
Marks(2, 5, 8) == win or
Marks(3, 6, 9) == win or
Marks(1, 5, 9) == win or
Marks(3, 5, 7) == win
)


# Now let's get down to business.
print ('Welcome to Noughts & Crosses.')

while True:
Play()
while True:
print ('Would you like to play again (y/n)?')
answer = Input()
if answer in ('y', 'n'):
break
if answer == 'n':
break
print ('Aight, resetting...')

print ('Aight, cya.')
print (bye)

/r/Python
https://redd.it/6qvu38

Sinuous Violin (elementary sound spectral analysis and synthesis with Python)
https://mapio.github.io/sinuous-violin/

/r/JupyterNotebooks
https://redd.it/6qzmbf

PySwarms - A particle swarm optimization (PSO) library in Python
https://github.com/ljvmiranda921/pyswarms

/r/Python
https://redd.it/6r26ug

How to use chromeless with Python?

Hello,
I wonder if there is any way to use this chromeless with Python?
https://github.com/graphcool/chromeless
It looks like a great tool but unfortunately i do not know if there is any way to use it with python.
Thank you

/r/Python
https://redd.it/6r2lsd

Which platform to quickly build a (paid) python-based API

Hi!

I have a python algorithm and I want to make a scalable web interface / API for that algorithm.

**First I would like to enable people to make call to my algorithm, either on the web interface or through a web api.**

- Which platform would be the best for me ? AWS lambda ? google app engine ? pythonanywhere ? something else ?

**Then if it works well I would like to create billing plans such as "ipinfo.io" (like 20 euros per month for X calls / X CPU time used...)**

- I know how to code in python / php but I don't see myself building the whole used authentification / billing plans.. payment tracking. Is there an easy platform to set up paid apis ?

Finally.. i'm poor so I can't afford to spend too much. I've seen 3scale for example but 750 euros is too much, especially considering that my algorithm is quite simple (like just a function with some arguments processed by a single python function, which gives back one or multiple numbers..).

Thanks!

/r/Python
https://redd.it/6r2r88

Django app that returns value based on what users choose in form (x-post r/django)

I did the tutorial on the Django website and made the polls app. I've since added static pages and gained a better understanding of how URLs and views work.
I've written a Python function that is essentially a logistic regression predictor. It takes in an array and based on that array returns a value.
I want to build off the polls app in Django, and make it so that instead of typing in an array, users can select from the poll form, and then the web app returns the value.
How would I go about starting this?

/r/djangolearning
https://redd.it/6r0q9e

Is this no longer the place to post notifications about Python library updates?

Lately, when I post notices about a new release of one of my Python libraries here, the post is pretty reliably downvoted. If people really don't care about the libraries I'm putting out, that's fine, but I just wanted to make sure I'm not violating a rule of some kind.

/r/Python
https://redd.it/6r3sbk

[P] Detecting the bats outside of my appartment by recognising their sound with Tensorflow
https://medium.com/@rmeertens/detecting-bats-by-recognising-their-sound-with-tensorflow-cdd5e1c22b14

/r/MachineLearning
https://redd.it/6r3kzd

[HELP] Left Join between multiple databases

I want to do a left join with another db, What would be the django equivalent of this query ?

USE PARTNER_DB;
SELECT CLIENT_ID, PARTNER.FIRST_NAME, PARTNER.LAST_NAME,
RPM, DRAWDOWN_PROTECTION, CONCAT(EMPLOYEE_DB.EMPLOYEE.FIRST_NAME, " ", EMPLOYEE_DB.EMPLOYEE.LAST_NAME),
EMPLOYEE_DB.EMPLOYEE.MAIL
FROM PARTNER
LEFT JOIN EMPLOYEE_DB.EMPLOYEE
ON RM_ID = EMPLOYEE_DB.EMPLOYEE.EMP_ID
WHERE CLIENT_ID = 'X1234'


I am using multiple databases in my project and both of these databases are not managed by django.

I tried to dig into django documentation but was unable to find a way to achieve this, instead i bumped into this
[https://docs.djangoproject.com/en/1.11/topics/db/multi-db/#no-cross-database-relations][1].

I am sure that there will be a hack / workaround this. Looking forward to your solutions.



**These are two different db's not managed by django.**

DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'PARTNER_DB',
'USER': 'root',
'PASSWORD': 'root',
'HOST': '127.0.0.1',
'PORT': '3306',
},
'employeedb': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'EMPLOYEE_DB',
'USER': 'root',
'PASSWORD': 'root',
'HOST': '127.0.0.1',
'PORT': '3306',
}
}

**My db models are**

class Partner(models.Model):
client_id = models.CharField(db_column='CLIENT_ID', primary_key=True, max_length=25)
first_name = models.CharField(db_column='FIRST_NAME', max_length=50)
last_name = models.CharField(db_column='LAST_NAME', max_length=50, blank=True, null=True)
mobile = models.CharField(db_column='MOBILE', max_length=10, blank=True, null=True)
active_from = models.DateField(db_column='ACTIVE_FROM')
rm_id = models.CharField(db_column='RM_ID', max_length=10, blank=True, null=True)
preferred_name = models.CharField(db_column='PREFERRED_NAME', max_length=50, blank=True, null=True)
rpm = models.IntegerField(db_column='RPM', blank=True, null=True)
drawdown_protection = models.IntegerField(db_column='DRAWDOWN_PROTECTION', blank=True, null=True)
depository_id = models.CharField(db_column='DEPOSITORY_ID', max_length=45, blank=True, null=True)
dob = models.DateField(db_column='DOB', blank=True, null=True)
account_type = models.CharField(db_column='ACCOUNT_TYPE', max_length=25, blank=True, null=True)
account_status = models.CharField(db_column='ACCOUNT_STATUS', max_length=25, blank=True, null=True)
first_holder_pan_number = models.CharField(db_column='FIRST_HOLDER_PAN_NUMBER', max_length=45, blank=True, null=True)
correspondence_address = models.CharField(db_column='CORRESPONDENCE_ADDRESS', max_length=1000, blank=True, null=True)
permanent_address = models.CharField(db_column='PERMANENT_ADDRESS', max_length=1000, blank=True, null=True)
nominee_name = models.CharField(db_column='NOMINEE_NAME', max_length=100, blank=True, null=True)
second_holder_name = models.CharField(db_column='SECOND_HOLDER_NAME', max_length=100, blank=True, null=True)
second_pan_number = models.CharField(db_column='SECOND_PAN_NUMBER', max_length=45, blank=True, null=True)
mail_id = models.CharField(db_column='MAIL_ID', max_length=200, blank=True, null=True)
bank_name = models.CharField(db_column='BANK_NAME', max_length=1000, blank=True, null=True)
bank_account_number = models.CharField(db_column='BANK_ACCOUNT_NUMBER', max_length=50, blank=True, null=True)
bank_micr_code = models.CharField(db_column='BANK_MICR_CODE', max_length=50, blank=True, null=True)
bank_ifsc_code = models.CharField(db_column='BANK_IFSC_CODE', max_length=50, blank=True, null=True)

class Meta:
managed = False
db_table = 'PARTNER'

class Employee

(models.Model):
emp_id = models.IntegerField(db_column='EMP_ID', primary_key=True)
first_name = models.CharField(db_column='FIRST_NAME', max_length=100)
last_name = models.CharField(db_column='LAST_NAME', max_length=100)
mail = models.CharField(db_column='MAIL', max_length=100)

class Meta:
managed = False
db_table = 'EMPLOYEE'


[1]: https://docs.djangoproject.com/en/1.11/topics/db/multi-db/#no-cross-database-relations


/r/django
https://redd.it/6r2kwt

The #1 reason Python rocks for data science
http://blog.datalifebalance.com/python-rocks-data-products/

/r/pystats
https://redd.it/6r5ote

Just wanna say thanks to flask,sqlalchemy,postgres and redis. I managed to create a server app that handles 7 Million requests per day. (probably more)

Proof:
http://imgur.com/a/n3mfG

I think it's one of my greatest achievement ever since we were only a 2-man team in the server dev.



/r/flask
https://redd.it/6r2gir