Pandas - TypeError: 'method' object is not subscriptable

Question

For a current project, I am among others converting data of a Pandas DataFrame.

When calling the line df['date'] = pd.to_datetime(df['date']), I am receiving the error TypeError: 'method' object is not subscriptable.

I have in this context already checked for some approached relating e.g. to missing parentheses but could not find a matching solution yet. Is there any smart tweak to make this run?

The code section is shown below:

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.DataFrame().fillna

# Datetime conversion
df['date'] = pd.to_datetime(df['date'])

please provide example of your data. it's hard to tell where the problem with converting data, with no idea how the data looks like — Roim
– Roim, Commented Jul 13, 2020 at 18:11
I'm voting to close this as a type or not reproducible given the () are missing in the fillna() function. — Celius Stingher
– Celius Stingher, Commented Jul 13, 2020 at 18:13
Thanks for your input. This amendment is however yielding the following error TypeError: fillna() missing 1 required positional argument: 'self' — Malte Susen
– Malte Susen, Commented Jul 13, 2020 at 18:32

etudiant · Accepted Answer · 2020-07-16 01:57:08Z

1

Instead of

df = pd.DataFrame().fillna

You should have called the fillna method.

df = df.fillna(method='bfill')

edited Jul 16, 2020 at 1:57

answered Jul 13, 2020 at 18:12

etudiant

1214 bronze badges

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

1 Comment

Malte Susen Over a year ago

Good idea - when using this line, I am however receiving the following error ValueError: Must specify a fill 'value' or 'method'.

Collectives™ on Stack Overflow

Pandas - TypeError: 'method' object is not subscriptable

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related