擅长:python、mysql、java
<p>将原始DF和“secstr”提取的DF组合起来,以删除不必要的列。这是否符合问题的意图</p>
<pre><code># Splitting the DF by 'Type'
df2 = df[df['Type'] == 'secstr']
df2.set_index(['PDB_ID','Chain'], inplace=True)
# Extract and divide 'Type' except 'secstr' ('sequence' extraction)
df = df[~(df['Type'] == 'secstr')]
df.set_index(['PDB_ID','Chain'], inplace=True)
# Combining DF and DF2 (in the column direction)
new_df = pd.concat([df,df2], axis=1)
new_df.reset_index(inplace=True)
# Renaming a column
new_cols = ['PDB_ID', 'Chain', 'Type', 'Sequence', 'Type1', 'Secstr']
new_df.columns = new_cols
# Deleting unnecessary columns
new_df.drop(columns=new_df.columns[[2,4]], inplace=True)
new_df
PDB_ID Chain Sequence Secstr
0 101M A HJGDSDDLKEIEWUSKDSK OLKDSJDJFYEUKIBK
1 102L A HJGDSDDLKEIEWUSKDSK OLKDSJDJFYEUKIBK
2 102M A HJGDSDDLKEIEWUSKDSK OLKDSJDJFYEUKIBK
3 103L A HJGDSDDLKEIEWUSKDSK OLKDSJDJFYEUKIBK
4 103M A HJGDSDDLKEIEWUSKDSK OLKDSJDJFYEUKIBK
</code></pre>