I’m wondering how to use the capitalize function when another column has a specific value.
For example, I want to change the first letter of students with Master’s degree.

I have multiple A* columns with corresponding B* columns (A and B have the corresponding numbers at the end of the column names).
When the REFNO value = A# value and the ‘MNGR’ is not BOB,
I need to put the value from corresponding B# column into the ‘AGE’ column and the corresponding # number in the ‘FLAG’ column

I am trying to read excel which is formulated means some values in excel is driven from formula I have tried two approach but I don’t receive any value. I get ‘None’. Can someone of you review my code and help me please?

I have an example dataframe:

enter image description hereI have the following dataframe as shown in the figure. I want to set the value of Column B based on the value in the column name that corresponds to Column A value. For example, Column A first row reads “Value A”, so look for Value A column and find “aaa”. Any hint on how to do this? Thank you

I have a data frame with 3 columns:

Hi there I have read a csv file using pd.read_csv()

I am trying to solve this problem with my code – I have developed a function in order to figure out the sum total of a value for a particular year using pandas dataframes.

With that code below, i can generate a dataframe with all business days between two dates, but i dont know how to filter to only be included in dataframe the first business day of each month.

I have a dataframe, df, such that when I print it out, it looks like: