Code Sample, a copy-pastable example if possiblefrom datetime import datetimeimport pandas as pdimport pytztz = pytz.tim...

Code Sample, a copy-pastable example if possibleIn [2]: ts = 1.4884427244831782e+18In [3]: pd.to_datetime(ts, utc=True)O...

pandas (0.19.2)rows is a list of dict from mysql.rows example[{'date': datetime.datetime(2017, 3, 21, 13, 27, 20), 'tid'...

Code Sample, a copy-pastable example if possiblea = df[(df.Gold>=1)&(df.Gold.1>=1)]Problem descriptionwhen I i...

Code Sample, a copy-pastable example if possibleIn [3]: df1 = pd.DataFrame({c : np.random.random(4) for c in ['a', 'b']}...

Code Sample, a copy-pastable example if possibleresult.to_hdf(op.join(args.output_dir, "merged.hd5"), "da...

Code Sample, a copy-pastable example if possibleimport datetimefrom pandas.tseries.offsets import CustomBusinessDayfrom ...

The astropy package is excellent for calculations with units!Is there a method to pass the Units (from astropy import un...

# Your code hereimport pandas as pdt = pd.Series([pd.Timestamp("2016-09-01", tz="US/Eastern") + k*pd...

import numpy as np import pandas as pddata = pd.DataFrame(np.arange(8).reshape(2,4)).set_index([0,1])print(type(data.ind...

Code Sample, a copy-pastable example if possibleimport pandas as pdimport numpy as npd = {'l': ['left', 'right', 'left'...

Code Sample, a copy-pastable example if possible# Your code hereProblem description[this should explain why the current ...

As I can see, this is the intended way to append one Series to anotherimport pandass = pandas.Series([0, 1, 2])new_s = s...

I know some people are philosophically opposed to it. I'm not sure where the pandas community stands, but I feel pandas...

read_excel() seems to give the same results for a multi-index column file if index_col=None or index_col=0. Using the f...

Code Sample, a copy-pastable example if possible# Your code heredata = pd.DataFrame( {'ab' : ['A','B','A','A','B'], 'num...

import datetimeimport pandas as pdvalues = [("a", datetime.date(2015,1,1), 30.), ...

I use the get_dummies function while feature engineering for scikit-learn classifiers. Something I realized is if a valu...

Code Sample, a copy-pastable example if possibleimport pandas as pdimport datetimeimport numpy as npbase = datetime.date...

Code Sample, a copy-pastable example if possibleimport mysql.connectorfrom sqlalchemy import create_engineimport pandas ...