Normalize data in pandas

In [92]: df
Out[92]:
           a         b          c         d
A  -0.488816  0.863769   4.325608 -4.721202
B -11.937097  2.993993 -12.916784 -1.086236
C  -5.569493  4.672679  -2.168464 -9.315900
D   8.892368  0.932785   4.535396  0.598124

In [93]: df_norm = (df - df.mean()) / (df.max() - df.min())

In [94]: df_norm
Out[94]:
          a         b         c         d
A  0.085789 -0.394348  0.337016 -0.109935
B -0.463830  0.164926 -0.650963  0.256714
C -0.158129  0.605652 -0.035090 -0.573389
D  0.536170 -0.376229  0.349037  0.426611

In [95]: df_norm.mean()
Out[95]:
a   -2.081668e-17
b    4.857226e-17
c    1.734723e-17
d   -1.040834e-17

In [96]: df_norm.max() - df_norm.min()
Out[96]:
a    1
b    1
c    1
d    1

Related Posts:

  1. ValueError: Unknown label type: ‘continuous’
  2. How to fix IndexError: invalid index to scalar variable
  3. Convert pandas dataframe to NumPy array
  4. ImportError: Missing required dependencies [‘numpy’]
  5. Python Pandas – Missing required dependencies [‘numpy’] 1
  6. ‘DataFrame’ object has no attribute ‘sort’
  7. ‘DataFrame’ object has no attribute ‘sort’
  8. TypeError: cannot unpack non-iterable int objec
  9. ‘DataFrame’ object has no attribute ‘sort’
  10. What is dtype(‘O’), in pandas?
  11. What is dtype(‘O’), in pandas?
  12. TypeError: ‘DataFrame’ object is not callable
  13. ValueError: ‘object too deep for desired array’
  14. What does axis in pandas mean?
  15. How to take column-slices of dataframe in pandas
  16. Creating a Pandas DataFrame from a Numpy array: How do I specify the index column and column headers?
  17. pandas create new column based on values from other columns / apply a function of multiple columns, row-wise
  18. Building multi-regression model throws error: `Pandas data cast to numpy dtype of object. Check input data with np.asarray(data).`
  19. Coalesce values from 2 columns into a single column in a pandas dataframe
  20. Concat DataFrame Reindexing only valid with uniquely valued Index objects
  21. Replacing Pandas or Numpy Nan with a None to use with MysqlDB
  22. Difference between data type ‘datetime64[ns]’ and ‘
  23. Merging two DataFrames
  24. Calculate weighted average using a pandas/dataframe
  25. vectorize conditional assignment in pandas dataframe
  26. ImportError: DLL load failed: The specified module could not be found
  27. Renaming column names in Pandas
  28. Delete a column from a Pandas DataFrame
  29. ValueError: setting an array element with a sequence
  30. Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
  31. What exactly does numpy.exp() do? [closed]
  32. Adding new column to existing DataFrame in Python pandas
  33. How to change the order of DataFrame columns?
  34. python numpy ValueError: operands could not be broadcast together with shapes
  35. Could not install packages due to a “Environment error :[error 13]: permission denied : ‘usr/local/bin/f2py'”
  36. How does numpy.newaxis work and when to use it?
  37. Create a Pandas Dataframe by appending one row at a time
  38. Should I use np.absolute or np.abs?
  39. How do I select rows from a DataFrame based on column values?
  40. How do I get the row count of a Pandas DataFrame?
  41. Error:cannot convert float NaN to integer in pandas
  42. Replacing column values in a pandas DataFrame
  43. Unable to plot Double Bar, Bar plot using pyplot for ndarray
  44. How do I get the row count of a Pandas DataFrame?
  45. Singular matrix issue with Numpy
  46. Get list from pandas dataframe column or row?
  47. Pandas DataFrame column to list
  48. Rename Pandas DataFrame Index
  49. Convert DataFrame column type from string to datetime, dd/mm/yyyy format
  50. How to raise a numpy array to a power? (corresponding to repeated matrix multiplications, not elementwise)
  51. Get a list from Pandas DataFrame column headers
  52. ‘End of statement expected’ in pycharm
  53. What does numpy.gradient do?
  54. ‘list’ object has no attribute ‘shape’
  55. load csv into 2D matrix with numpy for plotting
  56. Python TypeError: cannot convert the series to when trying to do math on dataframe
  57. Shuffle DataFrame rows
  58. Overcome ValueError for empty array
  59. index 1 is out of bounds for axis 0 with size 1
  60. Pytorch reshape tensor dimension
  61. Most efficient way to reverse a numpy array
  62. Convert a Pandas DataFrame to a dictionary
  63. Create a Pandas Dataframe by appending one row at a time
  64. Modify the legend of pandas bar plot
  65. Understanding NumPy’s einsum
  66. For loop and ‘numpy.float64’ object is not iterable error
  67. What are the causes of overflow encountered in double_scalars besides division by zero?
  68. How can I remove Nan from list Python/NumPy
  69. Map to List error: Series object not callable
  70. RuntimeWarning: numpy.dtype size changed, may indicate binary incompatibility
  71. Pandas DataFrame: replace all values in a column, based on condition
  72. How to convert string to datetime format in pandas python?
  73. Pandas – How to flatten a hierarchical index in columns
  74. Moving average or running mean
  75. How to start from second index for for-loop
  76. How to get a value from a cell of a dataframe?
  77. Groupby value counts on the dataframe pandas
  78. How to plot an array in python?
  79. How to create a numpy array of all True or all False?
  80. Pandas index column title or name
  81. Removing nan values from an array
  82. LinAlgError: Last 2 dimensions of the array must be square
  83. ImportError in importing from sklearn: cannot import name check_build
  84. import pandas_datareader gives ImportError: cannot import name ‘is_list_like’
  85. Root mean square of a function in python
  86. How to add pandas data to an existing csv file?
  87. What are the differences between numpy arrays and matrices? Which one should I use?
  88. Importing Pandas gives error AttributeError: module ‘pandas’ has no attribute ‘core’ in iPython Notebook
  89. cannot convert the series to
  90. Convert floats to ints in Pandas?
  91. pandas comparison raises TypeError: cannot compare a dtyped [float64] array with a scalar of type [bool]
  92. How to normalize a NumPy array to within a certain range?
  93. How to implement the ReLU function in Numpy
  94. Sorting arrays in NumPy by column
  95. Extract first and last row of a dataframe in pandas
  96. numpy : calculate the derivative of the softmax function
  97. Conditional indexing with Numpy ndarray
  98. Error in Reading a csv file in pandas[CParserError: Error tokenizing data. C error: Buffer overflow caught – possible malformed input file.]
  99. python numpy machine epsilon
  100. Extracting specific selected columns to new DataFrame as a copy

Leave a Comment