How should you reference the Unit Price column in the Python code?

You are creating a Python visual in Power Bl Desktop.

You need to retrieve the value of a column named Unit Price from a DataFrame.

How should you reference the Unit Price column in the Python code?
A . pandas.DataFrame(‘Unit Price’)
B. dataset[‘Unit Price’]
C. data = [Unit Price]
D. (‘Unit Price’)

View Answer

Answer: A

Explanation:

You can retrieve a column in a pandas DataFrame object by using the DataFrame object name, followed by the label of the column name in brackets.

So if the DataFrame object name is dataframe1 and the column we are trying to retrieve the ‘X’ column, then we retrieve the column using the statement, dataframe1[‘X’].

Here’s a simple Python script that imports pandas and uses a data frame:

import pandas as pd

data = [[‘Alex’,10],[‘Bob’,12],[‘Clarke’,13]]

df = pd.DataFrame(data,columns=[‘Name’,’Age’],dtype=float)

print (df)

When run, this script returns:

Name Age

0 Alex 10.0

1 Bob 12.0

2 Clarke 13.0

Explanation:

Reference: http://www.learningaboutelectronics.com/Articles/How-to-retrieve-a-column-from-a-pandas-dataframe-object-in-Python.php