Q5. Working with the “employees” table, select the data about all individuals, whose first name starts with “Mar”; specify that the name can be succeeded by any sequence of characters.
Emp_id
First_name
Last_name
Sex
Hire_date
1
Mark
Johnson
M
2021-06-27
2
Marcus
stoniss
M
2020-05-04
S3
Babita
Iyer
F
2021-06-18
4
Jethalal
Gada
M
2019-07-16
5
Neymar
Chapel
M
2019-08-09
6
Atmaram
Bhide
M
2018-09-10
7
Daya
Gada
F
2020-06-07
Q4. Extract the information about all department managers who were hired between the 1st of January 2020 and the 1st of January 2021.
DEPARTMENT MANAGER
Emp_id
First_name
Last_name
Sex
1
Aman
Rathore
M
2
Gaurav
Singh
M
5
Goli
Beta
M
7
Natu
Kaka
M
EMPLOYEES
Emp_id
Emp_name
Hire_date
1
Aman
2021-06-27
2
Gaurav
2020-05-04
3
Rohit
2021-06-18
4
Vimal
2019-07-16
5
Goli
2019-08-09
6
Shivam
2018-09-10
7
Natu
2020-06-07
Q1. The below list contains flowers and shrubs
We must make two separate lists one called flowers will only contain flower and the other called shrubs should only contain shrub .
Write the code to do the above mentioned.
data = [
"Andromeda - ...
Lemmatization generally means to do things properly with the use of vocabulary and morphological analysis of words. In this process, the endings of the words are removed to return the base word, which is also known as Lemma.
Example: boy’s = boy, ...
A Time Series is a sequential grouping of data that essentially speaks to how some values change after some time. Pandas contain broad capacities and highlights for working with time arrangement information for all areas. There are some properties:
Parsing time-series ...
Normally, NumPy is used to perform the most basic array manipulations like indexing, sorting, reshaping, basic elementary functions.
All mathematical code would reside in SciPy. Notwithstanding, one of NumPy's significant objectives is that it is compatible, so NumPy attempts to hold ...