Python实现从数据集中提取指定分组数据

Hey there! I get you need to pull out those 3 specific rows pointed to by the arrow in your dataset. Since I can't view image1, I'll share go-to methods for the most common tools folks use to handle data—pick the one that fits your workflow:

1. Excel/Google Sheets #

If you already know the exact row numbers of those 3 rows (like rows 6, 8, 10), it’s super straightforward:

• Just click the row number for each target row (hold Ctrl/Cmd to select multiple), right-click, and hit Copy. Paste them into a new sheet or file, and you’re done.
• If you want to dynamically pull them instead of copying (so updates reflect automatically), use the INDEX function. For example, if your data is in column B, pop this into a new cell:

  =INDEX(B:B,6)
  

  Swap out the row number for the other two rows to grab those too.

2. Python (with Pandas) #

If you’re working with code, Pandas is the go-to for this kind of task:

• First, load your dataset into a DataFrame. Then, if you know the 0-based row indices (Python starts counting at 0) of your target rows (say indices 3, 5, 7), use iloc:

  import pandas as pd
  # Load your data (adjust the file path/type as needed)
  df = pd.read_csv("your_data.csv")
  # Extract the specific rows
  extracted_rows = df.iloc[[3, 5, 7]]
  # Save the result to a new file if needed
  extracted_rows.to_csv("extracted_3rows.csv", index=False)
  

• If you don’t know the indices but can identify the rows by a column’s values (like a specific ID or label), use boolean filtering:

  # Replace "Column_Name" and the values with your actual data
  extracted_rows = df[df["Column_Name"].isin(["Target_Value1", "Target_Value2", "Target_Value3"])]
  

3. R #

For R users, here’s how to grab those rows:

• If you know the 1-based row numbers (R starts at 1), use bracket indexing:

  # Load your data
  df <- read.csv("your_data.csv")
  # Extract the target rows
  extracted_rows <- df[c(4, 6, 8), ]
  # Save to a new file
  write.csv(extracted_rows, "extracted_3rows.csv", row.names = FALSE)
  

• For value-based filtering, dplyr makes it clean:

  library(dplyr)
  extracted_rows <- df %>% filter(Column_Name %in% c("Target_Value1", "Target_Value2", "Target_Value3"))
  

If you can share a bit more detail—like what tool you’re using, or what makes those 3 rows unique (e.g., specific values in a column)—I can tweak this to be even more precise for your case!

内容的提问来源于stack exchange，提问作者Ali