pandas dataframe convert column type to string or categorical

You need astype:

df['zipcode'] = df.zipcode.astype(str)
#df.zipcode = df.zipcode.astype(str)

For converting to categorical:

df['zipcode'] = df.zipcode.astype('category')
#df.zipcode = df.zipcode.astype('category')

Another solution is Categorical:

df['zipcode'] = pd.Categorical(df.zipcode)

Sample with data:

import pandas as pd

df = pd.DataFrame({'zipcode': {17384: 98125, 2680: 98107, 722: 98005, 18754: 98109, 14554: 98155}, 'bathrooms': {17384: 1.5, 2680: 0.75, 722: 3.25, 18754: 1.0, 14554: 2.5}, 'sqft_lot': {17384: 1650, 2680: 3700, 722: 51836, 18754: 2640, 14554: 9603}, 'bedrooms': {17384: 2, 2680: 2, 722: 4, 18754: 2, 14554: 4}, 'sqft_living': {17384: 1430, 2680: 1440, 722: 4670, 18754: 1130, 14554: 3180}, 'floors': {17384: 3.0, 2680: 1.0, 722: 2.0, 18754: 1.0, 14554: 2.0}})

print (df)
       bathrooms  bedrooms  floors  sqft_living  sqft_lot  zipcode
722         3.25         4     2.0         4670     51836    98005
2680        0.75         2     1.0         1440      3700    98107
14554       2.50         4     2.0         3180      9603    98155
17384       1.50         2     3.0         1430      1650    98125
18754       1.00         2     1.0         1130      2640    98109

print (df.dtypes)
bathrooms      float64
bedrooms         int64
floors         float64
sqft_living      int64
sqft_lot         int64
zipcode          int64
dtype: object

df['zipcode'] = df.zipcode.astype('category')

print (df)
       bathrooms  bedrooms  floors  sqft_living  sqft_lot zipcode
722         3.25         4     2.0         4670     51836   98005
2680        0.75         2     1.0         1440      3700   98107
14554       2.50         4     2.0         3180      9603   98155
17384       1.50         2     3.0         1430      1650   98125
18754       1.00         2     1.0         1130      2640   98109

print (df.dtypes)
bathrooms       float64
bedrooms          int64
floors          float64
sqft_living       int64
sqft_lot          int64
zipcode        category
dtype: object

Related Posts:

  1. Dropping Multiple Columns from a data frame using Python
  2. how to sort pandas dataframe from one column
  3. Renaming column names in Pandas
  4. How to reset index in a pandas dataframe? [duplicate]
  5. how to reset index pandas dataframe after dropna() pandas dataframe
  6. How to deal with SettingWithCopyWarning in Pandas
  7. How to deal with SettingWithCopyWarning in Pandas
  8. Constructing pandas DataFrame from values in variables gives “ValueError: If using all scalar values, you must pass an index”
  9. How to iterate over rows in a DataFrame in Pandas
  10. How to iterate over rows in a DataFrame in Pandas
  11. Writing a pandas DataFrame to CSV file
  12. Selecting multiple columns in a Pandas dataframe
  13. Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
  14. Writing a pandas DataFrame to CSV file
  15. Adding new column to existing DataFrame in Python pandas
  16. How to change the order of DataFrame columns?
  17. How to change the order of DataFrame columns?
  18. Pandas DataFrame Groupby two columns and get counts
  19. How can I use the apply() function for a single column?
  20. How to show all columns’ names on a large pandas dataframe?
  21. How to groupby based on two columns in pandas?
  22. How to deal with SettingWithCopyWarning in Pandas
  23. Merging dataframes on index with pandas
  24. Create a Pandas Dataframe by appending one row at a time
  25. How to replace NaN values by Zeroes in a column of a Pandas Dataframe?
  26. ValueError: Length of values does not match length of index | Pandas DataFrame.unique()
  27. Convert Python dict into a dataframe
  28. Creating an empty Pandas DataFrame, then filling it?
  29. How do I select rows from a DataFrame based on column values?
  30. How do I select rows from a DataFrame based on column values?
  31. Pandas group-by and sum
  32. How do I get the row count of a Pandas DataFrame?
  33. Python pandas groupby aggregate on multiple columns, then pivot
  34. Convert pandas dataframe to NumPy array
  35. DataFrame constructor not properly called
  36. Convert pandas Series to DataFrame
  37. How to iterate over rows in a DataFrame in Pandas
  38. Pandas group-by and sum
  39. How do I get the row count of a Pandas DataFrame?
  40. How can I one hot encode in Python?
  41. ValueError: Length of values does not match length of index | Pandas DataFrame.unique()
  42. ‘DataFrame’ object has no attribute ‘sort’
  43. ‘DataFrame’ object has no attribute ‘sort’
  44. Python Package bt: Bool index error
  45. Rename Pandas DataFrame Index
  46. pandas: filter rows of DataFrame with operator chaining
  47. ‘DataFrame’ object has no attribute ‘sort’
  48. Pandas, merging two dataframes on multiple columns, and multiplying result
  49. Convert DataFrame column type from string to datetime, dd/mm/yyyy format
  50. Get a list from Pandas DataFrame column headers
  51. What is dtype(‘O’), in pandas?
  52. How to read a .xlsx file using the pandas Library in iPython?
  53. Get total of Pandas column
  54. What is dtype(‘O’), in pandas?
  55. How to check whether a pandas DataFrame is empty?
  56. Convert columns to string in Pandas
  57. Change column type in pandas
  58. ValueError: ‘object too deep for desired array’
  59. Shuffle DataFrame rows
  60. What does axis in pandas mean?
  61. How to take column-slices of dataframe in pandas
  62. Combine two columns of text in pandas dataframe
  63. Python: pandas merge multiple dataframes
  64. How to count the NaN values in a column in pandas DataFrame
  65. Pandas – DataFrame object is not callable
  66. Convert a Pandas DataFrame to a dictionary
  67. Convert pandas data frame to series
  68. Create a Pandas Dataframe by appending one row at a time
  69. Normalize columns of pandas data frame
  70. Normalize columns of pandas data frame
  71. Selecting/excluding sets of columns in pandas
  72. How to filter Pandas dataframe using ‘in’ and ‘not in’ like in SQL
  73. How to apply a function to two columns of Pandas dataframe
  74. Pandas DataFrame: replace all values in a column, based on condition
  75. OSError: Initializing from file failed on csv in Pandas
  76. Data type conversion error: ValueError: Cannot convert non-finite values (NA or inf) to integer
  77. Pandas – How to flatten a hierarchical index in columns
  78. Insert a row to pandas dataframe
  79. Subtract two columns in dataframe
  80. How to check if a column exists in Pandas
  81. Pandas error “Can only use .str accessor with string values”
  82. Pandas split DataFrame by column value
  83. Groupby value counts on the dataframe pandas
  84. Rename specific column(s) in pandas
  85. Pandas index column title or name
  86. Coalesce values from 2 columns into a single column in a pandas dataframe
  87. How to add pandas data to an existing csv file?
  88. Find the unique values in a column and then sort them
  89. if else function in pandas dataframe
  90. Read data (.dat file) with Pandas
  91. Move column by name to front of table in pandas
  92. pandas comparison raises TypeError: cannot compare a dtyped [float64] array with a scalar of type [bool]
  93. Pandas dataframe groupby plot
  94. Got continuous is not supported error in RandomForestRegressor
  95. Logical operators for Boolean indexing in Pandas
  96. vectorize conditional assignment in pandas dataframe
  97. Convert data.frame column to a vector?
  98. Convert list of dictionaries to a pandas DataFrame
  99. Compare two columns using pandas
  100. alueError: ordinal must be >= 1

Leave a Comment

tech