Have you ever worked on time series data, a dataset in which targets depends on the time and data. For this you have to convert the data set into time series dataset.
This data science python source code does the following:
1.Creating your own pandas series and timestams them.
2. Visualizes the series using seaborn libraries
So this is the recipe on we can generate timeseries using Pandas and Seaborn.
import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns
We have imported pandas, seaborn and matplotlib.pyplot which is needed.
We have created a dictionary of data and passed it in pd.DataFrame to make a dataframe. In the dictionary we have many features named 'date', 'regiment_1', 'regiment_2', etc. We have set index as date and rest other as features.
data = {'date': ['2014-05-01 18:47:05.069722', '2014-05-01 18:47:05.119994',
'2014-05-02 18:47:05.178768', '2014-05-02 18:47:05.230071',
'2014-05-02 18:47:05.230071', '2014-05-02 18:47:05.280592',
'2014-05-04 18:47:05.436523', '2014-05-04 18:47:05.486877'],
'regiment_1': [14, 26, 25, 14, 31, 25, 62, 41],
'regiment_2': [52, 66, 78, 15, 25, 25, 86, 1],
'regiment_3': [13, 26, 25, 62, 24, 14, 15, 15],
'regiment_4': [44, 15, 15, 14, 54, 25, 24, 72],
'regiment_5': [25, 24, 5, 25, 25, 27, 62, 5],
'regiment_6': [14, 15, 15, 14, 26, 25, 62, 24],
'regiment_7': [46, 57, 26, 15, 26, 25, 62, 41]}
df = pd.DataFrame(data, columns = ['date', 'regiment_1',
'regiment_2', 'regiment_3', 'regiment_4',
'regiment_5', 'regiment_6', 'regiment_7'])
df = df.set_index(df.date)
print(); print(df)
We have passed features from sns.tsplot to make time series plot of different features with index as date.
sns.tsplot([df.regiment_1, df.regiment_2, df.regiment_3, df.regiment_4,
df.regiment_5, df.regiment_6, df.regiment_7])
plt.show()
So the output comes as
date regiment_1 \ date 2014-05-01 18:47:05.069722 2014-05-01 18:47:05.069722 14 2014-05-01 18:47:05.119994 2014-05-01 18:47:05.119994 26 2014-05-02 18:47:05.178768 2014-05-02 18:47:05.178768 25 2014-05-02 18:47:05.230071 2014-05-02 18:47:05.230071 14 2014-05-02 18:47:05.230071 2014-05-02 18:47:05.230071 31 2014-05-02 18:47:05.280592 2014-05-02 18:47:05.280592 25 2014-05-04 18:47:05.436523 2014-05-04 18:47:05.436523 62 2014-05-04 18:47:05.486877 2014-05-04 18:47:05.486877 41 regiment_2 regiment_3 regiment_4 regiment_5 \ date 2014-05-01 18:47:05.069722 52 13 44 25 2014-05-01 18:47:05.119994 66 26 15 24 2014-05-02 18:47:05.178768 78 25 15 5 2014-05-02 18:47:05.230071 15 62 14 25 2014-05-02 18:47:05.230071 25 24 54 25 2014-05-02 18:47:05.280592 25 14 25 27 2014-05-04 18:47:05.436523 86 15 24 62 2014-05-04 18:47:05.486877 1 15 72 5 regiment_6 regiment_7 date 2014-05-01 18:47:05.069722 14 46 2014-05-01 18:47:05.119994 15 57 2014-05-02 18:47:05.178768 15 26 2014-05-02 18:47:05.230071 14 15 2014-05-02 18:47:05.230071 26 26 2014-05-02 18:47:05.280592 25 25 2014-05-04 18:47:05.436523 62 62 2014-05-04 18:47:05.486877 24 41