What am i doing wrong?
import json from datetime import datetime import pandas as pd f = open('message_1.json') data = json.load(f) for message in data["messages"]: timestamp = datetime.fromtimestamp(message["timestamp_ms"] / 1000) if 'content' not in message: rw = pd.DataFrame([timestamp,message["sender_name"],pd.NA], columns=['Date', 'Name', 'Comment']) else: rw = pd.DataFrame([timestamp,message["sender_name"], message["content"]], columns=['Date', 'Name', 'Comment']) rw.to_csv('igMess.csv',columns=["Date", "Name", "Comment"], header=None, index=None, mode='a') f.close()I get this error:
Error:ValueError: Shape of passed values is (3, 1), indices imply (3, 3)