Scribd
Upload
5 views1 page

Methods Table

The document lists various methods and functions used in data manipulation and analysis with pandas and other libraries. It includes functions for loading data, manipulating DataFrames, performing statistical operations, and visualizing data. Additionally, it covers methods for database connectivity and SQL execution.

Uploaded by

rishikal1212
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
5 views1 page

Methods Table

The document lists various methods and functions used in data manipulation and analysis with pandas and other libraries. It includes functions for loading data, manipulating DataFrames, performing statistical operations, and visualizing data. Additionally, it covers methods for database connectivity and SQL execution.

Uploaded by

rishikal1212
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

These are the methods used in the list of programs given.

[Link] Method / Function Description


1. pd.read_csv() Loads data from a CSV file into a pandas DataFrame
2. [Link]() Creates a pandas DataFrame from structured data or dictionary
3. head() Displays the first few rows of the DataFrame
4. dropna() Removes rows with missing (null) values
5. rename() Renames specified column(s) in the DataFrame
6. astype() Converts a column to a specified data type
7. print() Displays dataset or output on the console
8. Boolean Indexing (df[...]) Filters rows based on specified conditions
9. Comparison Operator (==) Selects rows where a column matches a specific value
10. Logical Operator (&) Combines multiple conditions for filtering
11. groupby() Groups data based on one or more columns
12. sum() Calculates totals within groups
13. reset_index() Resets index to default integer index
14. Column Selection (df[[...]]) Selects specific columns for analysis
15. StandardScaler() Initializes a scaler to standardize feature values
16. fit_transform() Fits scaler and transforms data
17. KMeans() Initializes K-Means clustering model
18. fit_predict() Trains model and assigns cluster labels
19. [Link]() Creates a new plotting figure
20. [Link]() Plots data points on a scatter plot
21. [Link]() Sets x-axis label
22. [Link]() Sets y-axis label
23. [Link]() Sets plot title
24. [Link]() Displays the plot
25. [Link]() Establishes MySQL database connection
26. cursor() Creates a cursor object for SQL execution
27. execute() Executes SQL queries
28. commit() Saves transaction to database
29. iterrows() Iterates over DataFrame rows

You might also like