Need help formatting dataframe data before saving to CSV

Thread Rating:

Thread Modes

Need help formatting dataframe data before saving to CSV

deanhystad

Super Moderators

Posts: 6,267

Threads: 16

Joined: Feb 2020

Reputation: 313

#14

Jun-30-2022, 08:23 PM

Since message is a dictionary you could also do this:

lv.append([
    timestamp.strftime("%m/%d/%Y"),
    timestamp.strftime("%I:%M:%S %p"),
    message["sender_name"],
    message.get("content", "")])

Messages In This Thread

RE: Need help formatting dataframe data before saving to CSV - by deanhystad - Jun-30-2022, 08:23 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Filter data into new dataframe as main dataframe is being populated	cubangt	8	1,101	Oct-23-2023, 12:43 AM Last Post: cubangt
	Seeing al the data in a dataframe or numpy.array	Led_Zeppelin	1	1,195	Jul-11-2022, 08:54 PM Last Post: Larz60+
	Problem in saving .xlsm (excel) file using pandas dataframe in python	shantanu97	2	4,430	Aug-29-2021, 12:39 PM Last Post: snippsat
	Reading data to python: turn into list or dataframe	hhchenfx	2	5,472	Jun-01-2021, 10:28 AM Last Post: Larz60+
	How to save json data in a dataframe	shantanu97	1	2,193	Apr-15-2021, 02:44 PM Last Post: klllmmm
	Formatting date in a dataframe	WiPi	1	1,809	Jan-06-2021, 11:26 AM Last Post: WiPi
	Pandas Extract data from two dataframe	nio74maz	1	2,221	Dec-26-2020, 09:52 PM Last Post: nio74maz
	Error when Excelwriter saving a dataframe with datetime datatype with timezone	klllmmm	3	13,704	Dec-08-2020, 11:37 AM Last Post: Larz60+
	saving data from text file to CSV file in python having delimiter as space	K11	1	2,444	Sep-11-2020, 06:28 AM Last Post: bowlofred
	Formatting Data/Time with Pyodbc and openpyxl	bearcats6001	0	2,320	Aug-17-2020, 03:44 PM Last Post: bearcats6001

Users browsing this thread: 1 Guest(s)