英文:
removing header and indexes when iterating the groups in pandas
问题
需要在迭代过程中删除每个组的标题。
我需要按几列分组，以及该组的数据框值。
import pandas as pddf = pd.read_excel('D:\\Python-pandas-numpy-mat_learn\\panda-learn\\test.xlsx')# 数据帧中的列为: ['col1', 'col2', 'col3', 'col4']grp = df.groupby(by=['col1', 'col2'])for each in grp.groups:print(df[(df['col1'] == each[0]) & (df['col2'] == each[1])])# 输出如下：col1 col2 col3 col49 32 321 12 5mldscol1 col2 col3 col40 123 34 44 Row11 123 34 66 Row2col1 col2 col3 col46 214 321 3255 ere# 希望的输出如下col1 col2 col3 col49 32 321 12 5mlds0 123 34 44 Row11 123 34 66 Row26 214 321 3255 ere
我不想要每个组的标题（['col1', 'col2', 'col3', 'col4']）和索引。
英文:
Need to remove header for each group while iterating.
I have requirement to group by few column and dataframe value for that group
import pandas as pddf=pd.read_excel('D:\\Python-pandas-numpy-mat_learn\\panda-learn\\test.xlsx')#column in dataframes are: ['col1','col2','col3','col4']grp=df.groupby(by=['col1','col2'])for each in grp.groups:print(df[(df['col1']==each[0]) & (df['col2']==each[1])])#Output is:col1 col2 col3 col49 32 321 12 5mldscol1 col2 col3 col40 123 34 44 Row11 123 34 66 Row2col1 col2 col3 col46 214 321 3255 ere#Want output likecol1 col2 col3 col432 321 12 5mlds123 34 44 Row1123 34 66 Row2214 321 3255 ere
I don't want headers (['col1','col2','col3','col4']) and indexes for each group
答案1
得分: 0
以下是代码部分的翻译：
grp=df.groupby(by=['col1','col2'])for i, (each, g) in enumerate(grp):print(g.to_string(index=False).split('\n', maxsplit=min(i,1))[-1])
输出结果：
col1 col2 col3 col432 321 12 5mlds123 34 44 Row1123 34 66 Row2214 321 3255 ere
英文:
Assuming you really need to use a loop, one option:
grp=df.groupby(by=['col1','col2'])for i, (each, g) in enumerate( grp):print(g.to_string(index=False).split('\n', maxsplit=min(i,1))[-1])
Output:
col1 col2 col3 col432 321 12 5mlds123 34 44 Row1123 34 66 Row2214 321 3255 ere
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论