idk how to ask Question maybe wrong way! id name salary 0 1 shyam 10000 1 2 ram 20000 2 3 ravi abc 3 4 abhay 30000 4 5 karan fgh *** expected *** id name salary 2 3 ravi abc 4 5 karan fgh >Solution : We can use str.contains as follows: df_out =… Read More filter rows from data where column salary has string datatype

I’ve a dataframe a b c one 6 11 one 7 12 two 8 23 two 9 14 three 10 15 three 20 25 I want to apply groupby at column a and then find the highest value in column c, so that, the highest value gets flagged, i.e. a b c one 6 11… Read More Pandas Groupby and Compare rows to find maximum value

Having a data set as below.Here I need to group the subset in column and fill the missing values using mode method. Need to group the value ‘Tom’ from name and fill the missing value in value using mode. Name Value 0 Tom 20.0 1 Tom 20.0 2 Tom NaN 3 nick 19.0 4 nick… Read More Grouping of subset of a Column in pandas

Let’ say I have the following dataset. How can I compute the average increase in times (I don’t know a proper word for this)? Meaning you know like I want to tell the audience, that the average temperature in 2021 increased this many times compared to 1980. Sample data (AvgTMean): structure(list(year = 1980:2021, AvgTMean =… Read More R compute average increase for a timeseries dataset

I am trying to do EDA with the Kaggle dataset link I made a plot with 3 subplots and have plotted 3 vertical lines on the basis of mean, median and mode. is there any way to show these 3 lines in a legend? This is my code def plott(data): fig, axes = plt.subplots(3, sharex=True,… Read More Legend in subplots() for vertical lines Matplotlib.pyplot Python