How to divide the cell into multiple cells?

user_16174112 0
Viewed 51

I have one csv file and first and third column we have date format as 1219376117 like first four digits is days(xxxx), hours(yy), minutes(zz), second(ss) as xxxxyyzzss respectively. Everything is in one cell, so how can I separate it?

import numpy as np
import math
import pandas as pd

df = pd.read_csv ('SensorsAP_example.csv')
print (df)


## Splitting the data sets
#df = pd.DataFrame({"Time stamp":["unchange"],"time_tow":["Days, hours, minutes, seconds"]})
python-3.x python database
2 Answers

One of the way is to first try and apply this to a simple string, which you can extend. E.g

s="1219376117"
days,hours,minutes,seconds=s[:4],s[4:6],s[6:8],s[8:]

Post that you can leverage apply function:

import pandas as pd
data={'timestamp':["1219376117","1219376118"]}
df=pd.DataFrame(data)

def split_timestamp(s):
   days,hours,minutes,seconds=s[:4],s[4:6],s[6:8],s[8:]
   return pd.Series([days,hours,minutes,seconds])
df[["days","hours","minutes","seconds"]]=df['timestamp'].apply(split_timestamp)

Output:

In [15]: df
Out[15]:
    timestamp  days hours minutes seconds
0  1219376117  1219    37      61      17
1  1219376118  1219    37      61      18
user_29863440

another option is using str.extract method:

df['time_tow'] = df['timestamp'].str.extract(r'(\d{4})(\d{2})(\d{2})(\d*)').agg(list,1)

>>> df
'''
    timestamp            time_tow
0  1219376117  [1219, 37, 61, 17]
1  1219376118  [1219, 37, 61, 18]
user_183445120
Related