Python century date process
I have a data with century date format below: date 0320316 NaN 1201102 I import the field to be str. What I want is: date date_new 0320316 19320316 NaN NaN 1201102 …
Tag: data-manipulation
Creating a new columns based on conditions from other columns
I have a dataframe that is something like this: Max Min Id 1 10 5 AAA 2 15 10 AAB 3 10 7 AAC 4 20 15 AAD 5 15 10 …
Python str.slice in apply function get AttributeError
I have a dataset like this: col1 col2 12345 N 450540 Y 356487 Y 000123 Y 111564 Y df[‘col3’] = df[[‘col1’, ‘col2’]].apply(lambda x: “N” if (x[‘col1’].str[…
Melt pandas dataframe containing column of dictionaries such that the dictionary values are also melted
This is not a duplicate This question: Pandas column dict split to new column and rows does not answer the question within this post. I have included an approach to converting a column of …