如何移除分割字符串中的无用字母及NBA球队DataFrame前缀冗余字符

Hey there! Let's break down solutions for your two needs, using Python (I'm assuming you're working with pandas for that DataFrame task):

First, when you split a string into a list and need to filter out unwanted characters/tokens, the key is defining what counts as "useless" (single letters, special symbols, etc.). Here's a flexible approach:

Suppose you have a split list like this:

split_list = ['*-', 'Houston', 'Rockets', 'x']

Option 1: Filter using a set of useless markers #

If you know exactly which characters/tokens are useless, create a set and filter the list with a comprehension:

# Define your set of useless characters/tokens (adjust as needed)
useless_items = {'*', '-', 'x', 'y', 'e'}

# Filter out useless items and empty strings
cleaned_list = [item for item in split_list if item not in useless_items and item.strip()]

Option 2: Use regex to keep valid words #

If you want to keep only multi-letter words (and exclude single characters/symbols), use a regex pattern to match valid entries:

import re

# Keep items that are letters/spaces and longer than 1 character
cleaned_list = [item for item in split_list if re.match(r'^[A-Za-z\s]+$', item) and len(item.strip()) > 1]

For your DataFrame where team names start with unwanted characters (like *-, y -, x -), we can use pandas' string replacement with regex to strip those leading junk:

First, let's simulate your raw data to test the solution:

import pandas as pd

raw_data = {
    'Teams': ['*-Houston Rockets', 'y -Golden State', 'x -Boston Celtics', 'x -Philadelphias', 'e -Denver Nuggets'],
    'W': [65, 58, 55, 52, 46],
    'L': [17, 24, 27, 30, 36],
    'Pct': [0.793, 0.707, 0.671, 0.634, 0.561]
}

df = pd.DataFrame(raw_data)

Now clean the Teams column:

# Replace any non-letter characters at the start of the string with nothing
df['Teams'] = df['Teams'].str.replace(r'^[^A-Za-z]+', '', regex=True)

# If you only want to target specific leading markers (like x/y/e/*/-), use this regex instead:
# df['Teams'] = df['Teams'].str.replace(r'^[xyed\*\-\s]+', '', regex=True)

If you print the cleaned DataFrame, you'll get exactly the format you want:

Teams   W   L    Pct
0  Houston Rockets  65  17  0.793
1    Golden State  58  24  0.707
2  Boston Celtics  55  27  0.671
3   Philadelphias  52  30  0.634
4   Denver Nuggets  46  36  0.561

The regex ^[^A-Za-z]+ works by matching any characters at the start of the string that aren't letters, then deleting them. The second regex is more targeted if you only need to remove specific symbols/tags.

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