Path: csiph.com!news.mixmin.net!news.unit0.net!fu-berlin.de!uni-berlin.de!not-for-mail
From: Joaquin Alzola <Joaquin.Alzola@lebara.com>
Newsgroups: comp.lang.python
Subject: Matplotlib X-axis dates
Date: Thu, 2 Jun 2016 15:45:22 +0000
Lines: 86
Message-ID: <mailman.99.1464883218.1839.python-list@python.org>
References: <HE1PR07MB13560091396C4A9B39B57C6FF0580@HE1PR07MB1356.eurprd07.prod.outlook.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Thread-Topic: Matplotlib X-axis dates
Thread-Index: AdG85NSCA9DGn4W0RxG/6R5Vq/9DSg==
Accept-Language: en-GB, en-US
Content-Language: en-US
spamdiagnosticoutput: 1:23
spamdiagnosticmetadata: NSPM
X-MS-Exchange-CrossTenant-originalarrivaltime: 02 Jun 2016 15:45:22.1602 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: d7093539-83cd-4991-b1b3-aacef74cf097
X-MS-Exchange-Transport-CrossTenantHeadersStamped: HE1PR07MB1355
X-Content-Filtered-By: Mailman/MimeDel 2.1.22
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.22
Precedence: list
List-Id: General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe: <https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive: <http://mail.python.org/pipermail/python-list/>
List-Post: <mailto:python-list@python.org>
List-Help: <mailto:python-list-request@python.org?subject=help>
List-Subscribe: <https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
X-Mailman-Original-Message-ID: <HE1PR07MB13560091396C4A9B39B57C6FF0580@HE1PR07MB1356.eurprd07.prod.outlook.com>
Xref: csiph.com comp.lang.python:109372

Hi Guys

Have been all day looking for a solution on the x-axis and the time plot.

The output that I get is this with all the dates shift to the right overlap=
ping each other. http://postimg.org/image/fs4tx83or/

I want the x-axis to start at 0 and to finish after the 3 entries on the DB=
.

X Axis should show (and it does but shift one over each other to the right)=
:
2016-06-02 11:15:00
2016-06-02 11:20:00
2016-06-02 11:25:00

Data on the Cassandra DB:
cqlsh:lebara_diameter_codes> select * from nl_lebara_diameter_codes;

country | service | date                            | errorcode2001 | error=
code3056 | errorcode4010 | errorcode4012 | errorcode4998 | errorcode4999 | =
errorcode5012
---------+---------+---------------------------------+---------------+-----=
----------+---------------+---------------+---------------+---------------+=
---------------
      NL |    gprs | 2016-06-02 11:15:00.000000+0000 |          3061 |     =
        0 |             1 |             0 |             0 |            50 |=
           741
      NL |    gprs | 2016-06-02 11:20:00.000000+0000 |          3204 |     =
        0 |             9 |             0 |             0 |            56 |=
           725
      NL |    gprs | 2016-06-02 11:25:00.000000+0000 |          3044 |     =
        0 |             8 |             0 |             0 |            64 |=
           722


Code:
sql =3D country_sql("NL",ago.strftime('%Y-%m-%d %H:%M:%S'),"gprs")
result =3D sql.sql_statement_range()
for i in result:
        country =3D i.country
        service =3D i.service
        x_list.append(i.date)
        code_2001.append(i.errorcode2001)
        code_4012.append(i.errorcode4012)
        code_4998.append(i.errorcode4998)
        code_4999.append(i.errorcode4999)
        code_5012.append(i.errorcode5012)
        code_3056.append(i.errorcode3056)
        code_4010.append(i.errorcode4010)

print(x_list)   --> Output is [datetime.datetime(2016, 6, 2, 11, 15), datet=
ime.datetime(2016, 6, 2, 11, 20), datetime.datetime(2016, 6, 2, 11, 25)]
#date_nump=3Ddate2num([i for i in x_list])
date_nump=3Ddate2num(x_list)
print(date_nump) --> output is [ 736117.46875     736117.47222222  736117.4=
7569444]
fig =3D plt.figure(figsize=3D(12,6))
ax =3D fig.add_subplot(111)
ax.set_title(country.upper() + " " + service,fontsize=3D16, fontweight=3D'b=
old')
plt.plot(np.array(code_2001),label=3D"2001")
plt.plot(np.array(code_3056),label=3D"3056")
plt.plot(np.array(code_4010),label=3D"4010")
plt.plot(np.array(code_4012),label=3D"4012")
plt.plot(np.array(code_4998),label=3D"4998")
plt.plot(np.array(code_4999),label=3D"4999")
plt.plot(np.array(code_5012),label=3D"5012")
lgd =3D plt.legend(loc=3D'center left', bbox_to_anchor=3D(1, 0.5))
ax.set_xscale('linear')
ax.set_xticks(date_nump)
ax.set_xticklabels(num2date(date_nump))
#ax.xaxis.set_major_locator(HourLocator(byhour=3Drange(0,24,2)))
ax.xaxis.set_major_formatter(DateFormatter('%Y-%m-%d %H:%M:%S'))
#ax.xaxis.set_minor_locator(MinuteLocator())
ax.grid(True,linestyle=3D'-',color=3D'0.75')
plt.gcf().autofmt_xdate(bottom=3D0.2, rotation=3D30, ha=3D'right')
plt.ylabel('Total Amount',fontsize=3D12, fontweight=3D'bold')
plt.xlabel('Date/Time',fontsize=3D12, fontweight=3D'bold')
plt.gca().set_ylim(bottom=3D0)
plt.savefig('testplot.png',bbox_extra_artists=3D(lgd,), bbox_inches=3D'tigh=
t')
plt.show()
This email is confidential and may be subject to privilege. If you are not =
the intended recipient, please do not copy or disclose its content but cont=
act the sender immediately upon receipt.