To clean and convert a whatsapp txt file export to a CSV file

watxt2csv.py

# To clean and convert a whatsapp txt file export to a CSV file

import pandas as pd

# read file by lines
file_path = "whatsapp.txt"
f = open(file_path, 'r')
data = f.readlines()
f.close()

# sanity stats
print('num lines: %s' %(len(data)))

# parse text and create list of lists structure
# remove first whatsapp info message
dataset = data[1:]
cleaned_data = []
for line in dataset:
	# grab the info and cut it out
	date = line.split(",")[0]
	line2 = line[len(date):]
	time = line2.split("-")[0][2:]
	line3 = line2[len(time):]
	name = line3.split(":")[0][4:]
	line4 = line3[len(name):]
	message = line4[6:-1] # strip newline charactor

	#print(date, time, name, message)
	cleaned_data.append([date, time, name, message])

  
# Create the DataFrame 
df = pd.DataFrame(cleaned_data, columns = ['Date', 'Time', 'Name', 'Message']) 

# check formatting 
if 0:
	print(df.head())
	print(df.tail())

# Save it!
df.to_csv(r'converted_messages.csv', index=False)

This is really great. Please can you assist me with a version of this in JavaScript ?

Thank you! I believe there are online converters now that should do the same thing