Replacing Pandas or Numpy Nan with a None to use with MysqlDB

@bogatron has it right, you can use where, it’s worth noting that you can do this natively in pandas: Note: this changes the dtype of all columns to object. Example: Note: what you cannot do recast the DataFrames dtype to allow all datatypes types, using astype, and then the DataFrame fillna method: Unfortunately neither this, nor using replace, works with None see this (closed) issue. As an aside, … Read more

Negation in Python

The negation operator in Python is not. Therefore just replace your ! with not. For your example, do this: For your specific example (as Neil said in the comments), you don’t have to use the subprocess module, you can simply use os.mkdir() to get the result you need, with added exception handling goodness. Example:

Python 3 print without parenthesis

Although you need a pair of parentheses to print in Python 3, you no longer need a space after print, because it’s a function. So that’s only a single extra character. If you still find typing a single pair of parentheses to be “unnecessarily time-consuming,” you can do p = print and save a few characters that way. … Read more

Open File in Another Directory (Python)

If you know the full path to the file you can just do something similar to this. However if you question directly relates to relative paths, that I am unfamiliar with and would have to research and test. Edit: Here is a way to do it relatively instead of absolute. Not sure if this works … Read more