Plot time AM/PM in Python
I have a list with taxi rides over a 24h period.
On the first column, called 'start_time' I have the start date of the ride in format HH:MM:SS AM or HH:MM:SS PM. Example 12:00:02 AM, 16:06:50 PM etc.
I want to make a plot to have on the x-axis the Hours of the day and on the y-axis the price for each race, by plotting the 'ride_value' column.
Data is stored in .csv format and I load it in JupyterNotebook using pandas
I assume I need to do a sort of transformation but from what I've found, something like taxi_data['hours'] = taxi_data['start_time'].dt.date doesn't work because it needs the data from 'start_time' to be in datetime format.
python matplotlib jupyter-notebook plotly
asked Nov 13 '18 at 18:03
Remus RaphaelRemus Raphael
166
add a comment |
I have a list with taxi rides over a 24h period.
On the first column, called 'start_time' I have the start date of the ride in format HH:MM:SS AM or HH:MM:SS PM. Example 12:00:02 AM, 16:06:50 PM etc.
I want to make a plot to have on the x-axis the Hours of the day and on the y-axis the price for each race, by plotting the 'ride_value' column.
Data is stored in .csv format and I load it in JupyterNotebook using pandas
I assume I need to do a sort of transformation but from what I've found, something like taxi_data['hours'] = taxi_data['start_time'].dt.date doesn't work because it needs the data from 'start_time' to be in datetime format.
python matplotlib jupyter-notebook plotly
asked Nov 13 '18 at 18:03
Remus RaphaelRemus Raphael
166
1
Can you show us what you've tried so far?
– Joel
Nov 13 '18 at 18:05
Also can you share a sample data?
– Naveen
Nov 13 '18 at 18:06
can you confirm whether the column 'start_time' is a datetime column?
– Adrish
Nov 13 '18 at 18:11
'start_time' contains only date-type format as HH:MM:SS AM/PM.
– Remus Raphael
Nov 13 '18 at 20:32
add a comment |
I have a list with taxi rides over a 24h period.
On the first column, called 'start_time' I have the start date of the ride in format HH:MM:SS AM or HH:MM:SS PM. Example 12:00:02 AM, 16:06:50 PM etc.
I want to make a plot to have on the x-axis the Hours of the day and on the y-axis the price for each race, by plotting the 'ride_value' column.
Data is stored in .csv format and I load it in JupyterNotebook using pandas
I assume I need to do a sort of transformation but from what I've found, something like taxi_data['hours'] = taxi_data['start_time'].dt.date doesn't work because it needs the data from 'start_time' to be in datetime format.
python matplotlib jupyter-notebook plotly
asked Nov 13 '18 at 18:03
Remus RaphaelRemus Raphael
166
I have a list with taxi rides over a 24h period.
On the first column, called 'start_time' I have the start date of the ride in format HH:MM:SS AM or HH:MM:SS PM. Example 12:00:02 AM, 16:06:50 PM etc.
I want to make a plot to have on the x-axis the Hours of the day and on the y-axis the price for each race, by plotting the 'ride_value' column.
Data is stored in .csv format and I load it in JupyterNotebook using pandas
I assume I need to do a sort of transformation but from what I've found, something like taxi_data['hours'] = taxi_data['start_time'].dt.date doesn't work because it needs the data from 'start_time' to be in datetime format.
python matplotlib jupyter-notebook plotly
python matplotlib jupyter-notebook plotly
asked Nov 13 '18 at 18:03
Remus RaphaelRemus Raphael
166
asked Nov 13 '18 at 18:03
Remus RaphaelRemus Raphael
166
edited Nov 13 '18 at 21:08
Remus Raphael
asked Nov 13 '18 at 18:03
Remus RaphaelRemus Raphael
166
asked Nov 13 '18 at 18:03
Remus RaphaelRemus Raphael
166
asked Nov 13 '18 at 18:03
Remus RaphaelRemus Raphael
166
166
1
Can you show us what you've tried so far?
– Joel
Nov 13 '18 at 18:05
Also can you share a sample data?
– Naveen
Nov 13 '18 at 18:06
can you confirm whether the column 'start_time' is a datetime column?
– Adrish
Nov 13 '18 at 18:11
'start_time' contains only date-type format as HH:MM:SS AM/PM.
– Remus Raphael
Nov 13 '18 at 20:32
add a comment |
1
Can you show us what you've tried so far?
– Joel
Nov 13 '18 at 18:05
Also can you share a sample data?
– Naveen
Nov 13 '18 at 18:06
can you confirm whether the column 'start_time' is a datetime column?
– Adrish
Nov 13 '18 at 18:11
'start_time' contains only date-type format as HH:MM:SS AM/PM.
– Remus Raphael
Nov 13 '18 at 20:32
1
1
Can you show us what you've tried so far?
– Joel
Nov 13 '18 at 18:05
Can you show us what you've tried so far?
– Joel
Nov 13 '18 at 18:05
Also can you share a sample data?
– Naveen
Nov 13 '18 at 18:06
Also can you share a sample data?
– Naveen
Nov 13 '18 at 18:06
can you confirm whether the column 'start_time' is a datetime column?
– Adrish
Nov 13 '18 at 18:11
can you confirm whether the column 'start_time' is a datetime column?
– Adrish
Nov 13 '18 at 18:11
'start_time' contains only date-type format as HH:MM:SS AM/PM.
– Remus Raphael
Nov 13 '18 at 20:32
'start_time' contains only date-type format as HH:MM:SS AM/PM.
– Remus Raphael
Nov 13 '18 at 20:32
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53287012%2fplot-time-am-pm-in-python%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53287012%2fplot-time-am-pm-in-python%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Can you show us what you've tried so far?
– Joel
Nov 13 '18 at 18:05
Also can you share a sample data?
– Naveen
Nov 13 '18 at 18:06
can you confirm whether the column 'start_time' is a datetime column?
– Adrish
Nov 13 '18 at 18:11
'start_time' contains only date-type format as HH:MM:SS AM/PM.
– Remus Raphael
Nov 13 '18 at 20:32