topic Re: AttributeError: 'DataFrame' object has no attribute 'rename' in Data Engineering

AttributeError: 'DataFrame' object has no attribute 'rename'

PHorniak — Tue, 30 Apr 2019 23:20:35 GMT

Hello, I am doing the Data Science and Machine Learning course.

The Boston housing has unintuitive column names. I want to rename them, e.g. so 'zn' becomes 'Zoning'.

When I run this command:

df_bostonLegible = df_boston.rename({'zn':'Zoning'}, axis='columns')

Then I get the error "AttributeError: 'DataFrame' object has no attribute 'rename'".

I did a websearch and found a few guides that were inapplicable:

https://stackoverflow.com/questions/28163439/attributeerror-dataframe-object-has-no-attribute-height/28163504

https://stackoverflow.com/questions/38134643/data-frame-object-has-no-attribute

Re: AttributeError: 'DataFrame' object has no attribute 'rename'

mathan_pillai — Wed, 01 May 2019 10:05:45 GMT

Hi @PHorniak

You can use

df_bostonLegible = df_boston.withColumnRenamed("zn", "Zoning")

please accept the answer if it works or revert back with questions

Thanks

Re: AttributeError: 'DataFrame' object has no attribute 'rename'

iosman — Wed, 01 May 2019 12:35:55 GMT

wow great information totally love it buddy.

Re: AttributeError: 'DataFrame' object has no attribute 'rename'

KrunalLathiya — Tue, 02 Jan 2024 10:50:36 GMT

If df_boston is a DataFrame, but you still face issues, try an alternative syntax: df_boston = df_boston.rename(columns={'zn': 'Zoning'}).

Make sure df_boston is a proper DataFrame and you're using a recent version of Pandas.