Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Using mathematica how do I plot histogram with data grouped by month (or week)?

Posted on 2011-09-23
2
769 Views
Last Modified: 2012-05-12
I am test driving Mathematica and I am stuck on trying to figure how to plot a histogram where the data is grouped by weekly or monthly dates.

Using:
ClosedPos1 = {#[[1, 1]], #[[2]]} & /@ SQLExecute[conn, "
   SELECT pDate, NumClosePos FROM stats__s1_c_long_tft3
   WHERE NumClosePos > 1
   "]

I have extraced from MySQL Database a list of dates, and a value. The list spans 2+ years and consist of daily dates.

I want to plot a histogram showing me the total  number of values which exist for each month. I then want to plot the same but using the total count for each week.

Here is a sample of the data:

{{{2009, 8, 19}, 2}, {{2009, 8, 20}, 4}, {{2009, 8, 21},
  4}, {{2009, 8, 24}, 3}, {{2009, 9, 3}, 4}, {{2009, 9, 8},
  2}, {{2009, 9, 9}, 5}, {{2009, 9, 10}, 5}, {{2009, 9, 17},
  2}, {{2009, 9, 18}, 2}, {{2009, 9, 21}, 2}, {{2009, 9, 28},
  5}, {{2009, 10, 2}, 2}, {{2009, 10, 12}, 5}, {{2009, 10, 21},
  2}, {{2009, 10, 23}, 3}, {{2009, 10, 28}, 4}, {{2009, 10, 30},
  5}, {{2009, 11, 2}, 5}, {{2009, 11, 5}, 4}, {{2009, 11, 9},
  3}, {{2009, 11, 16}, 6}, {{2009, 11, 18}, 4}, {{2009, 11, 30},
  2}, {{2009, 12, 1}, 13}, {{2009, 12, 2}, 3}, {{2009, 12, 3},
  2}, {{2009, 12, 10}, 3}, {{2009, 12, 14}, 6}, {{2009, 12, 16},
  4}, {{2009, 12, 17}, 2}, {{2009, 12, 18}, 7},
.......,

So, if I was summing weekly data the first plot would span
{2009, 8, 19}, 2}, {{2009, 8, 20}, 4}, {{2009, 8, 21}, 4},
which would be 2+4+4 = 10, and so on

If I was plotting monthly the each bar in the histogram would be the sum of the values for that month.

I would like to use FrameLabel to name the axis.

I have just spent 2 hours googling for some sample code but no luck.

Any help is appreciated!
0
Comment
Question by:John_2357
2 Comments
 
LVL 7

Accepted Solution

by:
karunamoorthy earned 500 total points
ID: 36938991
you want to get any code i.e. sql query so that it will give you values for weekwise/yearwise counts or
code for creating histogram in excel spread sheet.

What you want is matters here. Could you brief here what really you are looking for

0
 
LVL 1

Author Closing Comment

by:John_2357
ID: 37047697
b
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sql server computed columns 11 34
SQL Server 2012 r2 - Sum totals 2 28
Pre-Linear Regression Tests 2 25
SQL Query assistance 16 36
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Lithium-ion batteries area cornerstone of today's portable electronic devices, and even though they are relied upon heavily, their chemistry and origin are not of common knowledge. This article is about a device on which every smartphone, laptop, an…
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question