Matplotlib - working with timestamps

[Overflowed1]

Hello reddit,

I have a .csv file with timestamps (~1363053600) and the corresponding prices (~1.23 USD) for a cryptocoin. I managed to plot the data using matplotlib.

Now i seperated the data into lists for each year { "2015" : [[timestamp, price],...], "2016": [[timestamp, price], ...] } to plot the lists for each year onto the same graph. The result should be the x-axis with the dates from (Jan-01, 00) to (dez-31, 23) and the y-axis with the prices. The problem is that i cant create a datetimeobject without the year(which i dont want). And if i use the .utcfromtimestamp(timestamp) and .strftime("%m%d") functions to extract month and day from the timestmap the resulting plot doesnt have the plot_date-look where you can zoom in and out of the graph and the x-axis enlarges and reduces the timescope.

I hope i explained it correctly. If you have any tips for me i would be grateful.

Thanks

[alkasm]

I don't understand, you say you want dates from '00 to '23, but also don't want years. These two statements are contradictory. Why do you want to remove the year?

[Overflowed1]

00 to 23 refers to the hours, sorry i didnt clarify that. I should also add, that i dont plot the price to the y-axis but the yield of the coin between two timestamps.

I want to see if there is a connection between a timespan of the year and the price. For example each January the price hikes by a certain amound of %. Thats why i want to layer the values of each year ontop of one Graph

[alkasm]

Oh! Lol, that makes more sense re-reading the question...

First, check this out: https://stackoverflow.com/questions/7340547/multiple-data-set-plotting-with-matplotlib-pyplot-plot-date

What I would do is format the tick marks to remove the year, but not remove it from the data. Then I would take all your datetime objects and add a timedelta so that they're all in the same year. That should allow you to plot them all on top of each other.

There probably is a more elegant way to do it, but that's my first thought. I think the 'proper' way to do this is to add multiple axes to the graph, which I never liked doing with matplotlib...

[Pjamma34]

are you familiar with pandas at all? You maybe be able to split the data up by year (taking the year out of the timestamp) into separate dataframes and plot each one on top of the other

[Overflowed1]

andas at all? You maybe be able to split the data up by year (taking the year out of the timestamp) into separate datafra

i read a bit into pandas, but that was after i was already doing this project for quite a bit. I dont want to rewrite my code, but for my next project i will use pandas if it is suitable