My dataframe has a DOB column (example format 1/1/2016) which by default gets converted to Pandas dtype ‘object’. Converting this to date format with df[‘DOB’] = pd.to_datetime(df[‘DOB’]), the date gets converted to: 2016-01-26 and its dtype is: datetime64[ns]. Now I want to convert this date format to 01/26/2016 or any other general date format. How … Read more
I am processing a text file containing coordinates x, y, z 1 128 1298039 123388 0 2 …. every line is delimited into 3 items using words = line.split() After processing data I need to write coordinates back in another txt file so as items in each column are aligned right (as well as the … Read more
I am looking to format a number like 188518982.18 to £188,518,982.18 using Python. How can I do this? 15 Answers 15
Let’s say df is a pandas DataFrame. I would like to find all columns of numeric type. Something like: isNumeric = is_numeric(df) 12 Answers 12
I have an existing plot that was created with pandas like this: df[‘myvar’].plot(kind=’bar’) The y axis is format as float and I want to change the y axis to percentages. All of the solutions I found use ax.xyz syntax and I can only place code below the line above that creates the plot (I cannot … Read more
How would I generate a random date that has to be between two other given dates? The function’s signature should be something like this: random_date(“1/1/2008 1:30 PM”, “1/1/2009 4:50 AM”, 0.34) ^ ^ ^ date generated has date generated has a random number to be after this to be before this and would return a … Read more
How to disable logging on the standard error stream in Python? This does not work: import logging logger = logging.getLogger() logger.removeHandler(sys.stderr) logger.warning(‘foobar’) # emits ‘foobar’ on sys.stderr 19 Answers 19
I’m trying to format numbers. Examples: 1 => 1 12 => 12 123 => 123 1234 => 1,234 12345 => 12,345 It strikes as a fairly common thing to do but I can’t figure out which filter I’m supposed to use. Edit: If you’ve a generic Python way to do this, I’m happy adding a … Read more
I’m looking over the code for Python’s multiprocessing module, and it contains this line: from ._multiprocessing import win32, Connection, PipeConnection instead of from _multiprocessing import win32, Connection, PipeConnection the subtle difference being the period before _multiprocessing. What does that mean? Why the period? 3 Answers 3
Is there a way to get one value from a tuple in Python using expressions? def tup(): return (3, “hello”) i = 5 + tup() # I want to add just the three I know I can do this: (j, _) = tup() i = 5 + j But that would add a few dozen … Read more
