Pandas Pandas DATAFRAME to_sql PostgreSQL

# Your code hereimport pandas as pdimport sqlalchemysql='select * from stg.first_table limit 10'pg_engine='postgresql+ps...

Pandas Internals .apply Methods

core.internals.BlockManager.isna has what appears to be a typo: def isna(self, **kwargs): return self.apply('a...

Pandas Referencing commits

The docs state Please reference the relevant GitHub issues in your commit message using GH1234 or #1234. Either style i...

Pandas "rename" does not rename MultiIndex level

Code Sample, a copy-pastable example if possibleIn [2]: mi = pd.MultiIndex.from_tuples([(1,2), (3,4)])In [3]: pd.DataFra...

Pandas BUG: set() on pd.Series filled with NaNs hangs the kernel

Encountered via a column with all missing values read from a CSV that are filled by pd.csv_read as NaNs. I had logic to ...

Pandas Include non-numpy array in DataFrame

@jorisvandenbossche and I have been looking at Cythonizing some of GeoPandas. This has resulted in us having an object ...

Pandas chunksize argument removed from read_excel?

Code Sampleimport pandas as pdexcel = pd.ExcelFile("test.xlsx")for sheet in excel.sheet_names: reader = exc...

Pandas Variable deletion consumes a lot of memory

Hi team,I have been having issues with pandas memory management. Specifically, there is an (at least for me) unavoidable...

Pandas No roundtrip DataFrame.to/from_csv() with multiindex columns

Code Sample, a copy-pastable example if possibleimport pandas as pdimport numpy as np# create a dataframe with multiinde...

Pandas read_csv reads in CSV file as all NaNs if header is a list of length 1

Code SampleIf test.csv file looks like:a,b,c0,1,21,2,3Reading in the file with the header given in a list of length 0 re...

Pandas TestReadHtml.test_computer_sales_page - what's it doing?

@chris-b1 or anyone else, help a brother out? Can you tell me what this test does? It's just expecting the parser to thr...

Pandas Q: correct behavior for read_html with rowspan/colspan for DataFrames?

No code, just a question for proper behavior for rowspan/colspan with read_html of an HTML table into a DataFrame. (I'm ...

Pandas Adding a new DataFrame row using dict() gives unexpected behaviour

Code Sample, a copy-pastable example if possibleLink to StackOverflow exampleUsing pd.series works fine:df = pd.DataFram...

Pandas Multi-Index Dataframes do not cleanly support dimension-reducing arithmetic operations

Code Sample, a copy-pastable example if possible>>> import pandas as pd>>> df = pd.DataFrame(data = [[...

Pandas Return percentage of Null values in pd.Series.isnull()

Problem descriptionOne thing I have to check a lot at my work is the percentage of null values in a DataFrame column. Wh...

Pandas DOC: read_fwf() is documented as supporting delimiter, but doesn't

The docstring and online manual for read_fwf() say:delimiter : str, default NoneAlternative argument name for sep.But in...

Pandas rolling with datetimeIndex is not selecting anything when the row value is NaN itself

Code Sample, a copy-pastable example if possibleimport numpy as npimport pandas as pdimport datetimedf = pd.DataFrame({'...

Pandas Selection by labels with non-transitive equality

Code Sample, a copy-pastable example if possibleimport pandas as pdclass KV(object): def __init__(self, key, val): s...

Pandas Pandas can't read its own csv files

Code Sample, a copy-pastable example if possibleimport pandascol_a = ["Zenchef (formerly 1001menus) is the , éé eas...

Pandas Groupby inconsistency with categorical values

Code Sampledf = pd.DataFrame([{'i': i, 's': str(i)} for i in range(5)])# this gives two rows with counts of one, as expe...
上一页 下一页
.