Convert pandas series from string to unique int ids [duplicate]

by

You could use pandas.factorize:

In [32]: s = pd.Series(['a','b','c'])

In [33]: labels, levels = pd.factorize(s)

In [35]: labels
Out[35]: array([0, 1, 2])

More Related Contents:

  1. converting a text file to csv file with out index
  2. Get the row(s) which have the max value in groups using groupby
  3. Error: pandas hashtable keyerror
  4. Writing a pandas DataFrame to CSV file
  5. Remove unwanted parts from strings in a column
  6. pandas: How do I split text in a column into multiple rows?
  7. Find row where values for column is maximal in a pandas DataFrame
  8. How to filter rows containing a string pattern from a Pandas dataframe [duplicate]
  9. python/pandas: convert month int to month name
  10. How to check if a column exists in Pandas
  11. How to form tuple column from two columns in Pandas
  12. Convert pandas Series to DataFrame
  13. How to plot stacked event duration (Gantt Charts)
  14. Pandas still getting SettingWithCopyWarning even after using .loc
  15. Print very long string completely in pandas dataframe
  16. pandas comparison raises TypeError: cannot compare a dtyped [float64] array with a scalar of type [bool]
  17. How do I filter a pandas DataFrame based on value counts?
  18. Lambda including if…elif…else
  19. Pandas query function not working with spaces in column names
  20. Create bool mask from filter results in Pandas [duplicate]
  21. Getting a list of indices where pandas boolean series is True
  22. Pandas DataFrame sort by categorical column but by specific class ordering
  23. How can I remove extra whitespace from strings when parsing a csv file in Pandas?
  24. convert entire pandas dataframe to integers in pandas (0.17.0)
  25. Remove NaN values from pandas dataframe and reshape table [duplicate]
  26. Pandas groupby and aggregation output should include all the original columns (including the ones not aggregated on)
  27. Merging two tables with millions of rows in Python
  28. Selecting a range of columns in a dataframe
  29. Pandas data frame to dictionary of lists
  30. Pandas min() of selected row and columns

Leave a Comment