Pandas support sqlalchemy connections

I'd like to be able to manage my own connections and transactions with sqlalchemy:def foo(connection): pd.read_sql_qu...

Pandas 2 spaces in csv file between date and time

df.to_csv(path_or_buf=f, sep=' ', header=False, index=True, mode='a', quoting=QUOTE_NONE, escapechar=' '...

Pandas UnboundLocalError in pandas.io.data.get_data_yahoo

In [1]: %pasteimport pandas.io.data as weball_data = {}for ticker in ['AAPL', 'GOOG', 'IBM', 'YHOO', 'MSFT']: all_dat...

Pandas Value error on groupby bfill()

s = pd.Series([1,1,0], index=[1,2,2])s.groupby(s).fillna(method='bfill')I have a dataframe with a column containing some...

Pandas to_sql creates duplicate redundant constraints when exporting boolean columns

with pandas 0.16 and sqlalchemy, the to_sql method of a dataframe creates duplicate redundant constraints on each boolea...

Pandas pandas give a warning when working with np.NaN values

When I create a pandas.Series or pandas.DataFrame having np.NaN values, I get the following warning.Example:>>>...

Pandas Passing a list to level param of unstack() unexpectedly changes dtype from numeric to object

I experience these strange behavior of unstack() when its level parameter gets a list instead of string.This changes dty...

Pandas DateOffset & Timezones

tz = pytz.timezone('America/New_York')tz.localize(datetime.datetime(2007,3,12)) - DateOffset(days=1)# Timestamp('2007-03...

Pandas KeyError when key is present

I got a KeyError when running my program with pandas 0.15.2 on python 3.4.I have a TimeSeries created from a dp.read_sql...

Pandas pd.concat() fails with two large Series with datetime

I have two multi-index dataframes a_df and b_df. When I try to concat them, the operation fails, but it works if head th...

Pandas Pandas io data.py market data feed source in question

I was trying to fix a stock data feed error in data.py for python 2.7I used line 124 to look into the problem. # for co...

Pandas Series.sum has inconsistent return type

Series.sum returns a numpy type, except when it's empty, in which case it returns a python int of value "0":In [2]: type...

Pandas Problem subtracting two datetime64 columns with non unique index

Came a across this very odd problem while trying to get difference between two columns in a DataFrame of type datetime64...

Pandas Cannot get Yahoo option data using Remote Data Access of Pandas

I am trying to download Yahoo option data using the remote data access function of Pandas, I installed Anaconda on my la...

Pandas read_csv skiplines breaks in 0.15.2

I have been successfully parsing a csv file in 0.14.1, just upgraded yesterday and now the following code breaks:df = pd...

Pandas getting sqlalchemy datetime type ignores None timezones

When converting to datetime64, pandas does: if col_type == 'datetime64': try: tz = col...

Pandas BUG/SQL: to_sql sqlalchemy.exc.DataError for datetime64[ns] column in Redshift

I found that when using to_sql on a dataframe with a datetime64 column with most of the values being NaT, sqlalchemy fai...

Pandas PERF: make vbench runnable in python 3

I believe this is possible ATM.Comment From: jorisvandenbosscheI think we should also consider in looking into asv (airs...

Pandas Inconsistencies in DataFrame construction with MultiIndex.from_tuples

It's not clear to me that this is a "bug" per se, but it's certainly not intuitive behavior. My thought was that these t...

Pandas BUG: adding DatetimeIndex with series of timedeltas results in strange series

In [21]: dtidx = pd.date_range('2012-01-01', periods=2)In [22]: dtidxOut[22]:<class 'pandas.tseries.index.DatetimeInd...
上一页 下一页
.