问题

You can achieve the desired result by concatenating the values from the "MANUAL.ID" and "AUTO.ID" columns into a new "species" column in your data frame. Here's an example of how to do it in Python using the pandas library:

import pandas as pd

# Create your DataFrame
data = {'MANUAL.ID': ['Barbar', 'Barbar', 'Barbar', 'Barbar', 'Pippip', ''],
        'AUTO.ID': ['Barbar', '', 'Pippip', 'Pippip,Hypsav', 'Barbar', 'Barbar,Pippip']}
df = pd.DataFrame(data)

# Concatenate the values from both columns into a new 'species' column
df['species'] = df['MANUAL.ID'] + ',' + df['AUTO.ID']

# Display the resulting DataFrame
print(df[['species']])

This code will create a new "species" column in your DataFrame that contains the merged values from "MANUAL.ID" and "AUTO.ID," separated by a comma.

答案1

得分: 1

An approach using paste with apply

data.frame(species = apply(df, 1, function(x) 
  ifelse(any(x == ""), paste(x, collapse=""), paste(x, collapse=","))))
               species
1        Barbar,Barbar
2               Barbar
3        Barbar,Pippip
4 Barbar,Pippip,Hypsav
5        Pippip,Barbar
6        Barbar,Pippip

Data

df <- structure(list(MANUAL.ID = c("Barbar", "Barbar", "Barbar", "Barbar", 
"Pippip", ""), AUTO.ID = c("Barbar", "", "Pippip", "Pippip,Hypsav", 
"Barbar", "Barbar,Pippip")), row.names = c(NA, -6L), class = "data.frame")

(Note: I've translated the code part as requested.)

data.frame(species = apply(df, 1, function(x) 
  ifelse(any(x == ""), paste(x, collapse=""), paste(x, collapse=","))))
               species
1        Barbar,Barbar
2               Barbar
3        Barbar,Pippip
4 Barbar,Pippip,Hypsav
5        Pippip,Barbar
6        Barbar,Pippip

df <- structure(list(MANUAL.ID = c("Barbar", "Barbar", "Barbar", "Barbar", 
"Pippip", ""), AUTO.ID = c("Barbar", "", "Pippip", "Pippip,Hypsav", 
"Barbar", "Barbar,Pippip")), row.names = c(NA, -6L), class = "data.frame")