CODEWITHSUNDEEP
jsonpython-2.7pandas
WittyID
WittyID

Reputation: 619

Error on trying to use Dataframe.to_json method

I'm trying to export a pandas dataframe to JSON with no luck. I've tried:

all_data.to_json("spdata.json") and all_data.to_json()

I get the same attribute error on both: 'DataFrame' object has no attribute 'to_json'. Just to make sure something isn't wrong with the DataFrame, i tested writing it to_csv and that worked.

Is there something i'm missing in my syntax or package i need to import? I am running Python version 2.7.5 which is part of an Enthought Canopy Express package. Imports at the beginning of my code are:

from pandas import Series, DataFrame
import pandas as pd
import numpy as np
from sys import argv
from datetime import datetime, timedelta
from dateutil.parser import parse

Upvotes: 2

Views: 4821

Answers (1)

Andy Hayden
Andy Hayden

Reputation: 375475

The to_json method was introduced to 0.12, so you'll need to upgrade your pandas to be able to use it.

Upvotes: 3

Related Questions