Skip to content

Type Error Bug Despite Using Multiple Versions of Pandas #29638

@DataDoctorNG

Description

@DataDoctorNG

I have a data set of multiple work lists for my job and I am trying to sort values before dropping duplicates, but the code below give me this error:

import pandas as pd
Disputes = Disputes.sort_values(axis=1, by=['Invoice Number', 'Report Date'], inplace = True).drop_duplicates(subset=['Invoice Number', 'Report Date'], keep=['last'])

TypeError: sort_values() got an unexpected keyword argument 'by'

I have tried to use multiple versions of Pandas to fix the issue as has been suggested by multiple posts of Stack Overflow and on Github. However, I still get the same error.

Essentially I would like to use the sort values function without getting this error so that I can focus on the rest of my projects.

Here is the output to show my version of Pandas:

INSTALLED VERSIONS

commit : None
python : 3.7.3.final.0
python-bits : 64
OS : Windows
OS-release : 10
machine : AMD64
processor : Intel64 Family 6 Model 94 Stepping 3, GenuineIntel
byteorder : little
LC_ALL : None
LANG : None
LOCALE : None.None

pandas : 0.25.2
numpy : 1.17.3
pytz : 2019.3
dateutil : 2.8.1
pip : 19.3.1
setuptools : 41.6.0.post20191030
Cython : 0.29.12
pytest : 5.0.1
hypothesis : None
sphinx : 2.1.2
blosc : None
feather : None
xlsxwriter : 1.1.8
lxml.etree : 4.3.4
html5lib : 1.0.1
pymysql : None
psycopg2 : None
jinja2 : 2.10.3
IPython : 7.9.0
pandas_datareader: None
bs4 : 4.8.1
bottleneck : 1.2.1
fastparquet : None
gcsfs : None
lxml.etree : 4.3.4
matplotlib : 3.1.0
numexpr : 2.6.9
odfpy : None
openpyxl : 2.6.2
pandas_gbq : None
pyarrow : None
pytables : None
s3fs : None
scipy : 1.2.1
sqlalchemy : 1.3.5
tables : 3.5.2
xarray : None
xlrd : 1.2.0
xlwt : 1.3.0
xlsxwriter : 1.1.8

Metadata

Metadata

Assignees

No one assigned

    Labels

    Needs InfoClarification about behavior needed to assess issue

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions