Differences

This shows you the differences between two versions of the page.

--- programming:python:pandas [2023/07/20 02:10] – levor
+++ programming:python:pandas [2023/07/20 07:32] (current) – levor
@@ Line 11: / Line 11: @@
 | drop() | new_df = df.drop('row_title_to_drop')<pp>new_df = df.drop(list_of_row_titles_to_drop)<p>new_df = df.drop(index=2)<pp>new_df = df.drop(index=[3,4,6]) | function that returns a dataframe in which the row(s) have been removed.  |
 | equals() | same_data_b = df1.equals(df2) | function that returns a boolean, True if dataframes have the same information, otherwise returns False  |
-| columns.get_loc() | example | get integer location of column, by its name |
+| columns.get_loc() | (example?) | get integer location of column, by its name |
-| index.get_loc() | example | get integer location of row, by its name |
+| index.get_loc() | (example?) | get integer location of row, by its name |
-| .sort_values(column_name) | output_df = df.sort_values(by=[col_name_1, col_name_2, ...], ascending=True) | sort DataFrame by given colum(s)|
+| .sort_values(column_name) | output_df = df.sort_values(col_name)\\ output_df = df.sort_values(by=[col_name_1, col_name_2, ...], ascending=True) | sort DataFrame by given column(s)\\ NOTE: row-titles also move, so use iloc instead of loc|
 import pandas  # pip install pandas