Skip to content

Tag: python

Best way to find the last number in a String

I have images with variable names, the only consistant feature/thing is that the image number is located at the end of the name, just before the extension. For example: “im1.png”, “Image 02.tif”, “My3rdImage_3.jpg” , “Whatever_17_MoreWhatever-31.tiff”. What woul…

Replacing Double Quotes of Specific Column Entries in CSV File?

I have a huge CSV file with sample data that looks like so: The original CVS file had some unnecessary characters that I removed to obtain the data as shown above using the following code: Where I’m stuck now is, how do I replace the double quotes (“”) with single quotes (“) for all th…

Show Average Per Month

I have the following dataset: I am trying to create a graph using matplotlib that shows the average number of task by Month & Year. I was able to complete the calculations for average and was converted the date column to show only the Month and Year. However, when I go to plot, only the year appears. Plot…