AttributeError: module 'pandas' has no attribute 'df'

Question

For a current project, I am planning to clean a Pandas DataFrame off its Null values. For this purpose, I want to use Pandas.DataFrame.fillna, which is apparently a solid soliton for data cleanups.

When running the below code, I am however receiving the following error AttributeError: module 'pandas' has no attribute 'df'. I tried several options to rewrite the line df = pd.df().fillna, none of which changed the outcome.

Is there any smart tweak to get this running?

import string
import json
import pandas as pd

# Loading and normalising the input file
file = open("sp500.json", "r")
data = json.load(file)
df = pd.json_normalize(data)
df = pd.df().fillna

Aleksander Ikleiw · Accepted Answer · 2020-07-13 14:28:06Z

2

When you load the file to the pandas - in your code the data variable is a DataFrame instance. However, you made a typo.

df = pd.json_normalize(data)
df = df.fillna()

answered Jul 13, 2020 at 14:28

Aleksander Ikleiw

2,7152 gold badges11 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Malte Susen Over a year ago

Thanks for the input. This result is yielding ValueError: Must specify a fill 'value' or 'method'.. The approach df = pd.DataFrame().fillna seems to work however

Aleksander Ikleiw Over a year ago

@M.S. pandas.pydata.org/pandas-docs/stable/reference/api/… here are the docs. You need to set a few variables. If that works out please upvote my answer and accept it :) df = pd.DataFrame().fillna(value = ' DataFrame'should work out

Aleksander Ikleiw Over a year ago

@M.S. as it working, can you please accept my answer and upvote me? :))

Collectives™ on Stack Overflow

AttributeError: module 'pandas' has no attribute 'df'

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related