Fill In the Blanks For Python Pandas 2 Class 12 Informatics Practices

Fill In the Blanks For Python Pandas 2 Class 12 Informatics Practices

1. _____ The is the process of turning the values of a dataset (or a subset of it) into one single value.
2. The _____ function rearranges data into groups based on some criteria.
3. _____ function is used for finding the highest value from a given set of values or column of a dataframe or a series.
4. _____ is the process of rearranging the data from rows and columns.
5.  _____ function is used to add all of the values in a particular column of a dataframe.
6. Passing _____ argument skips the missing values by default.
7. _____ function calculates the most occurrence of each element along the axis selected.
8. _____ function in Python Pandas is used to calculate the median or middle value of a given set of numbers.
9. _____ in statistics are values that divide data into quarters.
10. The two functions available in Python Pandas for pivoting dataframe are _____ and _____.
11. _____ function is used to read the contents from an sql database into a dataframe.
12. _____ function is used to write the contents to an sql database from a dataframe.
13. _____ and _____ functions help you to iterate over a dataframe.
14. To add two dataframes, you may use functions _____ or _____.
15. To concatenate two string columns of a dataframe, _____ operator is used.
16. The _____ function returns the maximum repeating value.
17. The _____ function returns the average of given data.
18. The _____ function returns the halfway point in a given data.
19. Using _____ function you can calculate terciles.
20. Using _____ function you can calculate quartiles.
21. Using _____ function you can calculate octiles.
22. Using  _____ method, you can check if there are any missing values in dataframe.
23. To concatenate two dataframes, you can use _____ method.
24. The _____ function combines two dataframes such that two rows with some common value are merged together in the final result.
25. _____ function sorts on the basis of the values of a dataframe.
26. _____ function sorts on the basis of index of a dataframe.


Answer :-


1. Data Aggregation
2. groupby
3. max()
4. Pivoting
5. sum()
6. skipna = True
7. mode()
8. median()
9. Quartiles
10. pivot(), pivot_table()
11. read_sql()
12. .to_sql()
13. iterrows(), iteritems()
14. add or radd( )
15. +
16. mode()
17. mean()
18. median()
19. quantile()
20. quantile()
21. quantile()
22. isnull()
23. concat()
24. merge()
25. sort_values()
26. sort_index