sawant_ml

# Load the Pandas libraries with alias 'pd'
import pandas as pd
file_name = "filename"
# Read data from file 'filename.csv'
# (in the same directory that your python process is based)
# Control delimiters, rows, column names with read_csv (see later)
data = pd.read_csv(file_name)
#print(data.head)
data_frame1 = data[['ID', 'A', 'B', 'C', 'D']]
data_frame2 = data[['DateTime']]
#print(data_frame2.head())
data_frame2[['Date', 'Time']] = data_frame2.DateTime.str.split(' ', expand = True)
#print(data_frame2.head())
df = data_frame1.join(data_frame2)
df_final = df[['ID', "Date", "Time", "A", "B", "C", "D"]]
print(df_final.head())
df.to_csv("Sawant_chu 2.csv", sep='\t', encoding='utf-8')