applying regex to a pandas dataframe

by

When I try (a variant of) your code I get NameError: name 'x' is not defined— which it isn’t.

You could use either

df['Season2'] = df['Season'].apply(split_it)

or

df['Season2'] = df['Season'].apply(lambda x: split_it(x))

but the second one is just a longer and slower way to write the first one, so there’s not much point (unless you have other arguments to handle, which we don’t here.) Your function will return a list, though:

>>> df["Season"].apply(split_it)
74     [1982]
84     [1982]
176    [1982]
177    [1983]
243    [1982]
Name: Season, dtype: object

although you could easily change that. FWIW, I’d use vectorized string operations and do something like

>>> df["Season"].str[:4].astype(int)
74     1982
84     1982
176    1982
177    1983
243    1982
Name: Season, dtype: int64

or

>>> df["Season"].str.split("-").str[0].astype(int)
74     1982
84     1982
176    1982
177    1983
243    1982
Name: Season, dtype: int64

More Related Contents:

  1. Fast punctuation removal with pandas
  2. Create Pandas DataFrame from txt file with specific pattern
  3. How to filter rows in pandas by regex
  4. How to remove parentheses and all data within using Pandas/Python?
  5. re.sub erroring with “Expected string or bytes-like object”
  6. Strip / trim all strings of a dataframe
  7. pandas applying regex to replace values
  8. FutureWarning: The default value of regex will change from True to False in a future version
  9. Python: UserWarning: This pattern has match groups. To actually get the groups, use str.extract
  10. How to use str.contains() with multiple expressions in pandas dataframes
  11. How to parse complex text files using Python?
  12. How do I expand the output display to see more columns of a Pandas DataFrame?
  13. pandas create new column based on values from other columns / apply a function of multiple columns, row-wise
  14. Pandas get topmost n records within each group
  15. JSON to pandas DataFrame
  16. Multiple aggregations of the same column using pandas GroupBy.agg()
  17. Efficiently return the index of the first value satisfying condition in array
  18. PyInstaller and Pandas
  19. Pandas DataFrame column to list [duplicate]
  20. Bulk Insert A Pandas DataFrame Using SQLAlchemy
  21. How to plot multiple pandas columns
  22. Re.match() returns always none
  23. How to use regular expression in lxml xpath?
  24. Writing a Python Pandas DataFrame to Word document
  25. How does python and the regex module handle backslashes?
  26. Select row from a DataFrame based on the type of the object(i.e. str)
  27. How to annotate a seaborn barplot with the aggregated value
  28. Calculate summary statistics of columns in dataframe
  29. Average time for datetime list
  30. Create adjacency matrix for two columns in pandas dataframe

Leave a Comment