Code Explanation:
Importing Pandas
import pandas as pd
This imports the pandas library and gives it the alias pd.
Pandas is used for handling and analyzing data in a tabular (row-column) format.
Creating the DataFrame
df = pd.DataFrame({"A":[1, 2, 3, 4], "B":[3, 2, 1, 0]})
This creates a DataFrame with two columns:
Column A has values [1, 2, 3, 4]
Column B has values [3, 2, 1, 0]
At this point, df looks like a small table with four rows and two columns.
Adding a New Column “C”
df["C"] = df["A"] + df["B"]
This creates a new column C, which is the sum of A and B for each row.
Row-wise calculations:
1 + 3 = 4
2 + 2 = 4
3 + 1 = 4
4 + 0 = 4
So column C becomes [4, 4, 4, 4].
Creating Another Column “D”
df["D"] = df["C"] * 2
This multiplies each value in column C by 2.
Since every value in C is 4, column D becomes [8, 8, 8, 8].
Filtering Rows Where A > 2
filtered = df[df["A"] > 2]
This filters out rows where column A is greater than 2.
Only the rows with A = 3 and A = 4 remain in filtered.
Calculating the Final Result
result = filtered["D"].sum() + df.loc[0, "C"]
filtered["D"].sum() adds up all values in column D for the filtered rows → 8 + 8 = 16
df.loc[0, "C"] accesses the value in row 0, column C of the original DataFrame → 4
Finally, 16 + 4 = 20
Printing the Result
print(result)
This prints the final computed result.
Output:
20


0 Comments:
Post a Comment