Pandas Library

 

Pandas method python example

Here are some important Pandas methods in Python with simple examples.

1. Import Pandas

import pandas as pd

2. Create a DataFrame

data = {
    "Name": ["Rahul", "Priya", "Amit"],
    "Age": [21, 22, 20],
    "Marks": [85, 90, 78]
}

df = pd.DataFrame(data)

print(df)

3. head() – First records

print(df.head(2))

4. tail() – Last records

print(df.tail(2))

5. info() – Information about DataFrame

df.info()

6. describe() – Statistical summary

print(df.describe())

7. shape – Rows and columns

print(df.shape)

Output:

(3, 3)

8. Select a column

print(df["Name"])

9. Select multiple columns

print(df[["Name", "Marks"]])

10. loc[] – Select rows/columns by label

print(df.loc[0])

11. iloc[] – Select by index position

print(df.iloc[0:2])

12. Filter data

result = df[df["Marks"] > 80]

print(result)

13. sort_values() – Sort data

df = df.sort_values("Marks", ascending=False)

print(df)

14. drop() – Delete a column

df = df.drop("Age", axis=1)

print(df)

15. rename() – Rename columns

df = df.rename(columns={"Marks": "Score"})

print(df)

16. isnull() – Find missing values

print(df.isnull())

17. fillna() – Fill missing values

df["Score"] = df["Score"].fillna(0)

18. dropna() – Remove missing values

df = df.dropna()

19. value_counts() – Count values

print(df["Name"].value_counts())

20. groupby() – Group data

data = {
    "Department": ["IT", "HR", "IT", "HR"],
    "Salary": [40000, 35000, 50000, 45000]
}

df = pd.DataFrame(data)

print(df.groupby("Department")["Salary"].mean())

21. Read CSV file

df = pd.read_csv("students.csv")

print(df)

22. Save DataFrame to CSV

df.to_csv("output.csv", index=False)

Most commonly used Pandas methods:
head(), tail(), info(), describe(), loc[], iloc[], drop(), fillna(), dropna(), sort_values(), groupby(), value_counts(), read_csv(), and to_csv().