Sign Up

Have an account? Sign In Now

Sign In

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

You must login to ask question.

Forgot Password?

Need An Account, Sign Up Here

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Sign InSign Up

Softans

Softans Logo Softans Logo
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Add group
  • Groups page
  • Communities
  • Questions
    • New Questions
    • Trending Questions
    • Must read Questions
    • Hot Questions
  • Polls
  • Tags
  • Badges
  • Users
  • Help
Home/ Questions/Q 3573
In Process
Karl Max
Karl Max
Asked: September 5, 20222022-09-05T11:40:54+00:00 2022-09-05T11:40:54+00:00

Iterate through list but return prescribed index numbers grouped together

I’m trying to figure out how to loop through a df and return not just one row of data, but a prescribed group of data. Hard to explain so I’ll use a simple example

import pandas as pd

data = [['apple', 1], ['orange', 2], ['pear', 3], ['peach', 4],['plum', 5], ['grape', 6]]
#index_groups = [0],[1,2],[3,4,5]
df = pd.DataFrame(data, columns=['Name', 'Number'])

for i in range(len(df)):
    print(df['Number'][i])


       Name     Age
0      apple    1
1      orange   2
2      pear     3
3      peach    4
4      plum     5
5      grape    6

I need to know how to set my [i] to be either 0, (1&2), (3&4&5) (see the index_groups column)

I want to group my results but by a grouping I determine.

looppython
  • 0
  • 1 1 Answer
  • 24 Views
  • 0 Followers
  • 0
Answer
Share
  • Facebook
  • Report

1 Answer

  • Voted
  • Oldest
  • Recent
  1. Karl Max
    2022-09-05T11:41:13+00:00Added an answer on September 5, 2022 at 11:41 am

    Do you mean something like

    index_groups = [0], [1, 2], [3, 4, 5]
    for group in index_groups:
        print(df.loc[group])
    
        Name  Number
    0  apple       1
    
         Name  Number
    1  orange       2
    2    pear       3
    
        Name  Number
    3  peach       4
    4   plum       5
    5  grape       6
    

    If you want just Number column

    for group in index_groups:
        print(df['Number'].loc[group])
    • 0
    • Reply
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
      • Report

Leave an answer
Cancel reply

You must login to add an answer.

Forgot Password?

Need An Account, Sign Up Here

Sidebar

Ask A Question
  • Popular
  • Answers
  • Ghulam Nabi

    Why are the British confused about us calling bread rolls ...

    • 5 Answers
  • Alex

    application has failed to start because no appropriate graphics hardware ...

    • 4 Answers
  • Jerry

    Add file to native target programmatically via tuist/XcodeProj

    • 4 Answers
  • Ghulam Nabi
    Ghulam Nabi added an answer It seems like you're encountering a problem with your SQL… February 6, 2023 at 6:13 am
  • Ghulam Nabi
    Ghulam Nabi added an answer To add code coverage to a React project created without… February 3, 2023 at 7:01 am
  • Ghulam Nabi
    Ghulam Nabi added an answer You could try using the NetworkBoundResource architecture pattern. The idea… February 3, 2023 at 6:53 am

Trending Tags

android c++ cypress flutter java javascript python selenium testng webdriver

Top Members

Robert

Robert

  • 3 Questions
  • 1k Points
Luci

Luci

  • 5 Questions
  • 1k Points
Kevin O Brien

Kevin O Brien

  • 2 Questions
  • 1k Points

Explore

  • Home
  • Add group
  • Groups page
  • Communities
  • Questions
    • New Questions
    • Trending Questions
    • Must read Questions
    • Hot Questions
  • Polls
  • Tags
  • Badges
  • Users
  • Help

Footer

Softans

Softans is a social questions & Answers Engine which will help you establish your community and connect with other people.

About Us

  • Blog
  • Jobs
  • About Us
  • Meet The Team
  • Contact Us

Legal Stuff

Help

Follow

© 2021 Softans. All Rights Reserved
With Love by Softans.

Insert/edit link

Enter the destination URL

Or link to existing content

    No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.