(i) Write command to compute sum of every column of the data frame. -Technology

(i) Write command to compute sum of every column of the data frame. -Technology
by

1 Answer

Answer :

(i) df1.sum()(ii) df1[‘Rainfall’].mean()(iii) df1.loc[:11, ‘maxtemp’:’Rainfall’].mean( )
by

Related questions

Write the command using Insert() function to add a new column in the last place(3rd place) named “Salary” from the list Sal=[10000,15000,20000] -Technology

Description : Write the command using Insert() function to add a new column in the last place(3rd place) named “Salary” from the list Sal=[10000,15000,20000] -Technology

Last Answer : EMP.insert(loc=3,column=”Salary”,value=Sal)

Given the following Series S1 and S2: Write the command to find the sum of series S1 and S2 -Technology

Description : Given the following Series S1 and S2: Write the command to find the sum of series S1 and S2 -Technology

Last Answer : print(S1+S2)

Write a small python code to drop a row from data frame labeled as 0. -Technology

Description : Write a small python code to drop a row from data frame labeled as 0. -Technology

Last Answer : # Drop rows with label 0df = df.drop(0)print(df )

Write a python code to create a data frame with appropriate headings from the list given below : -Technology

Description : Write a python code to create a data frame with appropriate headings from the list given below : -Technology

Last Answer : import pandas as pd# initialize list of listsdata = [['S101', 'Amy', 70], ['S102', 'Bandhi', 69], ['S104','Cathy', 75], ['S105', 'Gundaho', 82]]# Create the pandas DataFramdf = pd.DataFrame(data, columns = ['ID', 'Name', 'Marks'])# printdataframe. print(df )

Write a program to compute the sum of all elements stored in an array using pointers.

Description : Write a program to compute the sum of all elements stored in an array using pointers.

Last Answer : #include #include void main() { int a[5],sum=0,i,*ptr; clrscr(); printf("\n Enter array elements:"); for(i=0;i

Compute the equivalent resistance of the network shown in A and B? -Technology

Description : Compute the equivalent resistance of the network shown in A and B? -Technology

Last Answer : 1 is correct

Write the HTML command to display the following in your Web page. -Technology

Description : Write the HTML command to display the following in your Web page. -Technology

Last Answer : The HTML command is – A2 + B2

Write the output on the Web page for the following HTML command. -Technology

Description : Write the output on the Web page for the following HTML command. -Technology

Last Answer : The output on the Web page will be the Atomic weight of O 2

Which tab and command let you insert animations in your slide? Write the steps for applying animations in your presentation. -Technology

Description : Which tab and command let you insert animations in your slide? Write the steps for applying animations in your presentation. -Technology

Last Answer : Animating Text and Objects:We can give sound effects or visual effects, including movement to the text or objects in a presentation. Animation can be used to focus on important points, to control the ... to animate the object.Effects appear in the Custom Animation list in the order that you add them

Write command for the operations (i) to (iii) based on the spreadsheet below: -Technology

Description : Write command for the operations (i) to (iii) based on the spreadsheet below: -Technology

Last Answer : 1. At cell F2, type =D2*E2 and then copy this formula using mouse Fill handle onto range F3: F5.2. At cell G2, type =IF(C2=”Consumable”, F2*0.07, F2*0.11) and then copy this formula using mouse Fill handle onto range G3: G5.3. At cell G6, type =SUM(G2: G5).

Write the Django command to start a new app named ‘users’ in an existing project? -Technology

Description : Write the Django command to start a new app named ‘users’ in an existing project? -Technology

Last Answer : python manage.py startapp users

Write the output of the following SQL command. select round (49.88); (a)49.88 (b)49.8 (c)49.0 (d)50 -Technology

Description : Write the output of the following SQL command. select round (49.88); (a)49.88 (b)49.8 (c)49.0 (d)50 -Technology

Last Answer : The correct answer is : (a) 50

Write the SQL command that will display the current time and date. -Technology

Description : Write the SQL command that will display the current time and date. -Technology

Last Answer : Select now();

Consider the following Series object, S_amt Table 350 Chair 200 Sofa 800 Stool 150 i. Write the command which will display the name -Technology

Description : Consider the following Series object, S_amt Table 350 Chair 200 Sofa 800 Stool 150 i. Write the command which will display the name -Technology

Last Answer : i. print(S_amt[S_amt>250])ii. S_amt.name= 'Furniture'

How to compute mean and standard deviation for each column of a pandas dataframe -Web-Development

Description : How to compute mean and standard deviation for each column of a pandas dataframe -Web-Development

Last Answer : answer:

What is the algorithm to compute the sum of even numbers between 7 and 50?

Description : What is the algorithm to compute the sum of even numbers between 7 and 50?

Last Answer : (7 to 50).filter(_ % 2 == 0).sum

Consider a full-adder with the following input values: (a) x=1, y=0 and Ci(carry input) = 0 (b) x=0, y=1 and Ci = 1 Compute the values of S(sum) and C0 (carry output) for the above input values. (A) S=1 , C0= 0 and S=0 , C0= 1 (B) S=0 , C0= 0 and S=1 , C0= 1 (C) S=1 , C0= 1 and S=0 , C0= 0 (D) S=0 , C0= 1 and S=1 , C0= 0

Description : Consider a full-adder with the following input values: (a) x=1, y=0 and Ci(carry input) = 0 (b) x=0, y=1 and Ci = 1 Compute the values of S(sum) and C0 (carry output) for the above input values. (A) S=1 , C0= 0 and ... C0= 1 (C) S=1 , C0= 1 and S=0 , C0= 0 (D) S=0 , C0= 1 and S=1 , C0= 0

Last Answer : (A) S=1 , C0= 0 and S=0 , C0= 1

What is the name of the column heading for each category in a data source? (a) Data field (b) Field (c) Field name (d) Record -Technology

Description : What is the name of the column heading for each category in a data source? (a) Data field (b) Field (c) Field name (d) Record -Technology

Last Answer : (c) Field name is the name of the column heading for each category in a data source.

Suggest the suitable data type for Issue_Date column. -Technology

Description : Suggest the suitable data type for Issue_Date column. -Technology

Last Answer : (i)Date(ii) alter table library modify name varchar(50);(iii) Bid column will always have a unique value which will help uniquely identify each record of Library table.(iv) Select name from library order by status desc;

While creating a table named “Employee”, Mr. Rishi got confused as which data type he should chose for the column “EName” out of char and varchar. -Technology

Description : While creating a table named “Employee”, Mr. Rishi got confused as which data type he should chose for the column “EName” out of char and varchar. -Technology

Last Answer : Varchar would be the suitable data type for EName column as char data type is a fixed length data type while varchar is a variable length data type.Any employee‟s name will be of variable length so it‟s advisable to choose varchar over char data type.

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?

Description : For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame?

Last Answer : Yes

A command tab which allows to create the table in an interactive manner is called (a) Home -Technology

Description : A command tab which allows to create the table in an interactive manner is called (a) Home -Technology

Last Answer : (d) MS-Access provides a command tab named Create which allows creating the table in an interactive manner.

Explain the given command <a href =”wild.html”>Click Here for wild animals</a> -Technology

Description : Explain the given command Click Here for wild animals -Technology

Last Answer : In this command, anchor tag and its href attribute are included. The text (Click Here for wild animals) will appear underlined and indicates that clicking the text activates the hypertext link. The address ... is an URL or Web page address and Click Here for wild animals is the hyperlinked text.

Which command should be use to link a page with HTML page? (a) <a link = “page.htm” > </a> -Technology

Description : Which command should be use to link a page with HTML page? (a) -Technology

Last Answer : (b) page

Sona wants to add her pictures in a Word document. 1. Which tab she should use? 2. Which command she should use to open Insert Picture dialog box? -Technology

Description : Sona wants to add her pictures in a Word document. 1. Which tab she should use? 2. Which command she should use to open Insert Picture dialog box? -Technology

Last Answer : 1. Insert tab2. Picture command in the Illustrations group.3. Yes4. Yes

…….. command is used to move the text to a new page. -Technology

Description : …….. command is used to move the text to a new page. -Technology

Last Answer : Page breakcommand is used to move the text to a new page.

Rehearse Timings command is present on ………………. tab. (a) Animations (b) Review (c) Slide Show (d) View -Technology

Description : Rehearse Timings command is present on ………………. tab. (a) Animations (b) Review (c) Slide Show (d) View -Technology

Last Answer : c) Rehearse Timings command is present on Slide Show tab.

………………. provides a command to change the layout of your slide. -Technology

Description : ………………. provides a command to change the layout of your slide. -Technology

Last Answer : Home tab provides a command to change the layout of your slide.

The Custom Animation command is present on ………………. tab. -Technology

Description : The Custom Animation command is present on ………………. tab. -Technology

Last Answer : The Custom Animationcommand is present on Animationstab.

Which command we use to link a page with an HTML page? -Technology

Description : Which command we use to link a page with an HTML page? -Technology

Last Answer : link textuse to link a page with an HTML page .

What is the function of ALTER command? -Technology

Description : What is the function of ALTER command? -Technology

Last Answer : Alter command is used to change/modify the structure of database object like a table, index, etc.

The command used to give a heading to a graph is .... (a) plt.show() (b) plt.plot() (c) plt.xlabel() (d) plt.title() -Technology

Description : The command used to give a heading to a graph is .... (a) plt.show() (b) plt.plot() (c) plt.xlabel() (d) plt.title() -Technology

Last Answer : (d)plt.title()

Given a Pandas series called Sequences, the command which will display the first 4 rows is .... (a) print(Sequences.head(4)) -Technology

Description : Given a Pandas series called Sequences, the command which will display the first 4 rows is .... (a) print(Sequences.head(4)) -Technology

Last Answer : (a) print(Sequences.head(4))

The ....... command can be used to makes changes in the rows of a table in SQL. -Technology

Description : The ....... command can be used to makes changes in the rows of a table in SQL. -Technology

Last Answer : The update command can be used to makes changes in the rows of a table in SQL.

(1) Prachi has given the following command to obtain the highest marks Select max(marks) from student where group by class; -Technology

Description : (1) Prachi has given the following command to obtain the highest marks Select max(marks) from student where group by class; -Technology

Last Answer : (1)d. Select class, max(marks) from student group by class;(2)b. Both (ii) and (iv)(3)b. select name,max(DOB) from student;

The frame attribute contains types of values. (a) 9 (b) 3 -Technology

Description : The frame attribute contains types of values. (a) 9 (b) 3 -Technology

Last Answer : (a) The frame attribute contains 9 types of values.

border, frame, cellspacing, cellpadding, align are the attributes of (a) <body> tag (b) <img> tag -Technology

Description : border, frame, cellspacing, cellpadding, align are the attributes of (a) tag (b) tag -Technology

Last Answer : (c) border, frame, cellspacing, cellpadding, align are the attributes of tag.

Name any two values specified in frame attribute. -Technology

Description : Name any two values specified in frame attribute. -Technology

Last Answer : The values that can be specified for frame attribute are void and above.

frame attribute is used with…………attribute. -Technology

Description : frame attribute is used with…………attribute. -Technology

Last Answer : frame attribute is used with borderattribute.

Using which option, you can create a frame for several shapes. -Technology

Description : Using which option, you can create a frame for several shapes. -Technology

Last Answer : Insert —> Illustrations —> Shapes —> New Drawing Canvas option is used to create a frame for several shapes.

Explain the various values associated with “scrolling” attribute of FRAME tag. -Technology

Description : Explain the various values associated with “scrolling” attribute of FRAME tag. -Technology

Last Answer : The scrolling attribute of FRAME tag can take 3 values:Yes will insert both the scrolls irrespective of the size of the sub-window.Auto will insert the scrolls only when the contents of the sub-window are not visible.No will not insert any scrolls even when all the contents are not visible.

What is the purpose of the description column in table Design View? -Technology

Description : What is the purpose of the description column in table Design View? -Technology

Last Answer : (a) A Design View of the table provides three columns as Field Name, Data Type, and Description. The description column provides the facility to write the description about Field Name.

Which attribute of <td> tag is used to merge two or more columns to form a single column? (a) colspan (b) cellspacing -Technology

Description : Which attribute of tag is used to merge two or more columns to form a single column? (a) colspan (b) cellspacing -Technology

Last Answer : (a) colspan attribute is used to merge two or more columns to form a single column.

A cell is an intersection of a row and a column. -Technology

Description : A cell is an intersection of a row and a column. -Technology

Last Answer : True A cell is an intersection of a row and a column.

The <td> tag (column setting) have higher priority than <tr> tag (row setting). -Technology

Description : The tag (column setting) have higher priority than tag (row setting). -Technology

Last Answer : True The tag (column setting) have higher priority than tag (row setting).

<th>‘tag is used to specify the column heading in a table. -Technology

Description : ‘tag is used to specify the column heading in a table. -Technology

Last Answer : True tag is used to specify the column heading in a table.

…………. splits text in columns at a specific point. (a) Column break (b) Page break (c) Next page (d) Continuous -Technology

Description : …………. splits text in columns at a specific point. (a) Column break (b) Page break (c) Next page (d) Continuous -Technology

Last Answer : (a) Column bj;eak splits text in columns at a specific pointing.

Soham has clicked on the cell residing at the intersection of first row and ninth column. What will be the address of the selected cell? -Technology

Description : Soham has clicked on the cell residing at the intersection of first row and ninth column. What will be the address of the selected cell? -Technology

Last Answer : First row and ninth column address will be II.

First row and ninth column address will be II. -Technology

Description : First row and ninth column address will be II. -Technology

Last Answer : There are two methods of adding a new worksheet iasm Excel workbook; Insert worksheet tab at the bor >m and Insert button on cells group under Home tab.

What will be the column names of the below statement? -Technology

Description : What will be the column names of the below statement? -Technology

Last Answer : 1. 26th column: Z2. 28th column: AB