Question: here is some peice of the python code which i was working on and I am stuck where i need to plot a graph with

here is some peice of the python code which i was working on and I am stuck where i need to plot a graph with datetime on x axis and sum on the y axis. Please help me plot this graph in python

import numpy as np import pandas as pd import matplotlib.pyplot as plt import datetime from bokeh.plotting import figure, output_file, show

columns = ['datetime', 'sum', 'mchine']

cdr = pd.read_csv('', sep=',', names=columns) cdr['datetime'] = cdr['datetime'].str.extract(r'(\d\d\d\d-\d\d-\d\d-\d\d:\d\d).*?') cdr['datetime'] = pd.to_datetime(cdr['datetime'], format="%Y-%m-%d-%H:%M")

#print(cdr) cdr2 = cdr.groupby(['datetime','mchine'])['sum'].sum()

pd.set_option('display.max_rows', 500) print(cdr2)

csv file:

2018-02-23-01:57:06.190+0000: 12 datarun
2018-02-23-01:57:06.198+0000: 12 datarun
2018-02-23-01:57:06.203+0000: 12 datarun
2018-02-23-01:57:06.207+0000: 12 datarun
2018-02-23-01:57:06.211+0000: 12 datarun
2018-02-23-01:57:06.214+0000: 12 datarun
2018-02-23-01:57:06.221+0000: 12 datarun
2018-02-23-01:57:06.225+0000: 12 datarun
2018-02-23-01:59:06.670+0000: 84 datarun
2018-02-23-02:15:25.669+0000: 776 datarun
2018-02-23-02:15:27.381+0000: 832 datarun
2018-02-23-02:15:28.601+0000: 880 datarun
2018-02-23-02:15:28.620+0000: 920 datarun
2018-02-23-02:15:31.698+0000: 964 datarun
2018-02-23-02:15:31.713+0000: 1012 datarun
2018-02-23-02:15:33.363+0000: 1056 datarun
2018-02-23-02:15:33.397+0000: 1096 datarun
2018-02-23-02:15:35.385+0000: 1100 datarun
2018-02-23-02:16:03.185+0000: 1348 datarun
2018-02-23-02:16:03.350+0000: 1424 datarun
2018-02-23-02:16:03.366+0000: 1500 datarun
2018-02-23-02:16:03.415+0000: 1600 datarun
2018-02-23-02:16:03.429+0000: 1668 datarun
2018-02-23-02:16:03.507+0000: 1292 datarun
2018-02-23-02:16:56.309+0000: 316 datarun
2018-02-23-02:16:56.396+0000: 316 datarun
2018-02-23-02:16:56.460+0000: 632 datarun
2018-02-23-02:16:59.785+0000: 724 datarun
2018-02-23-02:16:59.798+0000: 736 datarun
2018-02-23-02:16:59.872+0000: 724 datarun
2018-02-23-02:16:59.872+0000: 736 datarun
2018-02-23-02:16:59.916+0000: 1020 datarun
2018-02-23-02:16:59.917+0000: 1008 datarun
2018-02-23-02:17:00.106+0000: 752 datarun
2018-02-23-02:17:00.110+0000: 740 datarun
2018-02-23-02:17:00.285+0000: 724 datarun
2018-02-23-02:17:00.320+0000: 724 datarun
2018-02-23-02:17:00.332+0000: 1016 datarun
2018-02-23-02:17:00.395+0000: 736 datarun
2018-02-23-02:17:00.411+0000: 744 datarun
2018-02-23-02:17:00.426+0000: 736 datarun
2018-02-23-02:17:00.447+0000: 1032 datarun
2018-02-23-02:17:00.511+0000: 752 datarun
2018-02-23-02:17:00.920+0000: 724 datarun
2018-02-23-02:17:00.959+0000: 724 datarun
2018-02-23-02:17:00.966+0000: 736 datarun
2018-02-23-02:17:00.983+0000: 1012 datarun
2018-02-23-02:17:00.996+0000: 736 datarun
2018-02-23-02:17:01.005+0000: 736 datarun
2018-02-23-02:17:01.023+0000: 1020 datarun
2018-02-23-02:17:01.048+0000: 736 datarun
2018-02-23-02:17:01.049+0000: 740 datarun
2018-02-23-02:17:01.061+0000: 1028 datarun
2018-02-23-02:17:01.079+0000: 748 datarun
2018-02-23-02:17:01.115+0000: 752 datarun
2018-02-23-02:17:01.255+0000: 736 datarun
2018-02-23-02:17:01.286+0000: 740 datarun
2018-02-23-02:17:01.312+0000: 1028 datarun
2018-02-23-02:17:01.369+0000: 752 datarun
2018-02-23-02:17:01.406+0000: 616 datarun
2018-02-23-02:17:01.962+0000: 12 datarun
2018-02-23-02:17:01.969+0000: 12 datarun
2018-02-23-02:17:01.975+0000: 12 datarun
2018-02-23-02:17:01.980+0000: 12 datarun
2018-02-23-02:17:01.988+0000: 12 datarun
2018-02-23-02:17:01.993+0000: 12 datarun
2018-02-23-02:17:01.998+0000: 12 datarun
2018-02-23-02:17:02.001+0000: 12 datarun
2018-02-23-02:17:13.135+0000: 364 datarun
2018-02-23-02:17:13.135+0000: 364 datarun
2018-02-23-02:17:13.144+0000: 372 datarun
2018-02-23-02:17:13.150+0000: 372 datarun
2018-02-23-02:17:13.151+0000: 372 datarun
2018-02-23-02:17:13.152+0000: 372 datarun
2018-02-23-02:17:13.152+0000: 364 datarun
2018-02-23-02:17:13.152+0000: 372 datarun
2018-02-23-02:17:25.625+0000: 1200 datarun
2018-02-23-02:17:26.087+0000: 1184 datarun
2018-02-23-02:17:26.346+0000: 1196 datarun
2018-02-23-02:17:26.351+0000: 1204 datarun
2018-02-23-02:17:26.645+0000: 1200 datarun
2018-02-23-02:17:26.931+0000: 1192 datarun
2018-02-23-02:17:27.033+0000: 1188 datarun
2018-02-23-02:17:27.205+0000: 1196 datarun
2018-02-23-02:17:28.705+0000: 1268 datarun
2018-02-23-02:17:28.798+0000: 1280 datarun
2018-02-23-02:17:28.801+0000: 1412 datarun
2018-02-23-02:17:28.876+0000: 1436 datarun
2018-02-23-02:17:28.916+0000: 428 datarun
2018-02-23-02:17:28.926+0000: 432 datarun
2018-02-23-02:17:29.193+0000: 1284 datarun
2018-02-23-02:17:29.254+0000: 1432 datarun
2018-02-23-02:17:29.294+0000: 1288 datarun
2018-02-23-02:17:29.341+0000: 432 datarun
2018-02-23-02:17:29.376+0000: 1436 datarun
2018-02-23-02:17:29.459+0000: 432 datarun
2018-02-23-02:17:29.477+0000: 1520 datarun
2018-02-23-02:17:29.483+0000: 1496 datarun
2018-02-23-02:17:29.536+0000: 216 datarun
2018-02-23-02:17:29.545+0000: 216 datarun

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Expert please complete this correctly scipy.integrate.quad scipy.integrate. quad (func, a, b, args=(), full_output=0, epsabs=1.49e-08, epsrel=1.49e-08, limit=50, wvar=None, wopts=None, maxp1=50,...

Q:

Using the template thats given, fill in the python code while following the given guidelines in order to output a binary tree similar to the one shown. Be sure to include a function at global scale...

Q:

plz give me the python code and necessary explanation of this question thx file president's.csv file sp500_daily.csv Many U.S. presidents have attempted to take credit for the strong performance of...

Q:

It seems very long but it only takes 5 minutes, please help me. using Matlab to solve. Combined Temperature, Windspeed, and Direction Plot Goal: Plot temperature, wind speed, and direction with...

Q:

test() 1 Overview Lab 6 will cover tuples and random number generation, both of which are used in this program. I suggest you view this document on the computer (as opposed to a black and white print...

Q:

complete this python code from the images and the comments in the code: import matplotlib.pyplot as plt PI = 3.141592653589793238 M= float(1.989e+30) #[kg] #weight of the sun G= float(6.67e-11) #[m3...

Q:

complete this python code by looking at the comments and images: here is the code: import matplotlib.pyplot as plt PI = 3.141592653589793238 M= float(1.989e+30) #[kg] #weight of the sun G=...

Q:

python Assignment: (requirement :complete this code:) import matplotlib.pyplot as plt PI = 3.141592653589793238 M= float(1.989e+30) #[kg] #weight of the sun G= float(6.67e-11) #[m3 kg-1 s-2]...

Q:

JupyterLab Hi, Im not understanding what Im looking at for my Biostats class and my professor is not answering my emails please help me if you can. I don't understand at all. Thank you so much bit. B...

Q:

Describe, and estimate the costs of, procedures to (a) insert a new item into an existing heap; (b) delete the topmost item from a non-empty heap; (c) starting from an array holding N items in...

Q:

Your brother calls you on the phone telling you that Googles share price has fallen by about 25% over the past few days. Now you can own one small slice of Google for only $540 a share (the price on...

Q:

The course has offered a glimpse into reality TVs production techniques, messages, and effects on individuals and society. Through an understanding of the concepts and methods for studying reality...

Q:

On the client, a web browser is used to render the HyperText Markup Language ( HTML ) . Question 3 options: True False

Q:

CT Corp Comprehensive Question Canadian Tire Corporation, Limited ( Canadian Tire ) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Q:

3. Identify the methods used within each of the three approaches.

Q:

2. Describe three approaches to the study of intercultural communication.

Q:

3. How have the worldviews of researchers influenced how they studied intercultural communication?