Subscribe to DSC Newsletter


I am working on a Project on Time Series Data. I need to segment customer who have similar time series trends. Can someone guide me how to approach such Time Series Clustering issues.

Tags: Cluster, Patterns, Time

Views: 514

Reply to This

Replies to This Discussion


This is Biswajit represent StatSoft India. We will appreciate if you can share your details & particulars to discuss in length & details.Anticipate & expect may contribute & add value to your current project.

Thanks !
I assume when you say "trend" you mean long-run stocastic trend. The only way I know of extracting long-run stocastic trend information is through cointegration techniques. Moving average or ARIMA models will not do it. However, you need a lot of observations to make identification of cointegrated time series meaningful. The data can be analyzed in an unrestricted VAR model and then tested. The CATS for RATS program will do this, as will several other econometric packages. Good luck. -jr
Rubin, Thank You for all your suggestion and time. I try those models and contact you for any further advice.

Biswajit, the data is about consumer transaction variable collected for every month for 12 months period. We have thousands of consumers. We need to see whether there are common patterns in consumer spending by clustering techniques.
Hi Kartteek,

This is Biswajit represent StatSoft India creator & publisher of STATISTICA since 1984.We embed approximate 6,00,000 & 1000 Users globally & in India trust,confidence & reference to our engagement.We have a product called STATISTICA AUTOMATED NEURAL NETWORK (SANN) for predictive analytics address the areas of Regression,Time Series,Cluster, Classification for a 360 degree technical view you may reach us [email protected] or + 91 98913 93138 (M)

Thanks !
Thanks for your suggestion Goldrick. I used Correspondence Analysis as you mentioned, but I'm not sure how good to use this for mining large database.Could you please give me some example or applications on time series data.

Atul, My data has

Cust_ID, Amount spent in M1 M2 M3 M4 ... M12 month.

I need to cluster customers who have common spending patterns. i.e I expect to see cluster of customers who spend more during Christmas.

Thanks for your time.
Sorry Goldrick, I was working on some other project and couldn't able to respond. I tried doing hierarchical clustering on eigen vectors since we have lot of consumer data. Our results shows that there are peak transactions almost in every month. Should validate these results looking into other parameters.

Anyway Thanks for your guidance.
hello karteek

i will suggest u about this problem, just make clusters of your customers then u can simply make a 3d histogram taking cluster number on one axis and month on the other axis(any software will do this for u).
this may give u a picture of which spending patterns of group of customers in different months

I would really appriciate if u could share with me if you want to make clusters of comsumers or the consumption
Did you mention what platform you are on? Microsoft's Sequence Clustering algorithm in SQL Server Analysis Services is designed to address that kind of a problem--sequence patterns. Also, I would think that web analytics software might have something to offer as sequences of clicks on websites are critical, but I have very limited experience with that.


On Data Science Central

© 2019 is a subsidiary and dedicated channel of Data Science Central LLC   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service