NameError: name 'df' is not defined(Python)

Question

Below is the code i am trying to use in python, have tried everything.Can anyone please help ..

import pandas as pd
# Using DataFrame.astype() function
df["Date"] = df["Date"].astype('datetime64[ns]')
print (df.dtypes)

---------------------------------------------------------------------------
NameError                                 Traceback (most recent call last)
Cell In[24], line 3
      1 import pandas as pd
      2 # Using DataFrame.astype() function
----> 3 df["Date"] = df["Date"].astype('datetime64[ns]')
      4 print (df.dtypes)

NameError: name 'df' is not defined

I had tried to import library and other google solution but not solved.

Does this answer your question? Array name is not defined in python NameError — LeopardShark
– LeopardShark, Commented Mar 6, 2023 at 12:05

Erik Fubel · Accepted Answer · 2023-03-06 13:16:32Z

-1

You never define the DataFrame df through df = pd.DataFrame(). Try

import pandas as pd

# Define df
df = pd.DataFrame(columns=["Date"])

# Using DataFrame.astype() function
df["Date"] = df["Date"].astype('datetime64[ns]')
print(df.dtypes)

edited Mar 6, 2023 at 13:16

answered Mar 6, 2023 at 12:01

Erik Fubel

7215 silver badges17 bronze badges

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

3 Comments

aryan Over a year ago

File ~\AppData\Local\Programs\Python\Python311\Lib\site-packages\pandas\core\indexes\base.py:3804, in Index.get_loc(self, key, method, tolerance) 3802 return self._engine.get_loc(casted_key) 3803 except KeyError as err: -> 3804 raise KeyError(key) from err 3805 except TypeError: 3806 # If we have a listlike key, _check_indexing_error will raise 3807 # InvalidIndexError. Otherwise we fall through and re-raise 3808 # the TypeError. 3809 self._check_indexing_error(key) KeyError: 'Date'

aryan Over a year ago

you suggestion works very well but again stuck at above error

Erik Fubel Over a year ago

@aryan I've adjusted my solution accordingly. It now creates a DataFrame with an empty "Date" column first and then changes the datatype of it to "datetime64[ns]". Hope this helps :)

Collectives™ on Stack Overflow

NameError: name 'df' is not defined(Python)

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related