Subtract two columns in dataframe

Given the following dataframe:

df = pd.DataFrame([["Australia", 1, 3, 5],
                   ["Bambua", 12, 33, 56],
                   ["Tambua", 14, 34, 58]
                  ], columns=["Country", "Val1", "Val2", "Val10"]
                 )

It comes down to a simple broadcasting operation:

>>> df["Val1"] - df["Val10"]
0    -4
1   -44
2   -44
dtype: int64

Related Posts:

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

Leave a Comment