Search & Filtering
1. The following assets were invested in the enterprise; cash, 3500, accounts Receivable 950 supplies 1200; and photographic equipment 15000. There were no liabilities transferred to the business.
v March 1. Paid 2400 on for 3 moths office rent
v March 4. Purchased photographic equipment on account for 2500
v March 5. Received 850 from credit customers
v March 6. Paid 125 for advertisement( Miscell.exp)
v March 10. Paid 500 to settle March 4 debt
v March 13. Paid 575 for two weeks’ salary
v March 16. Received 1,980 from sale of service
v March 20. Paid 650 for supplies purchase
v March 27. Paid 575 for two weeks’ salary
v March 31. Paid 69 for telephone bill for the month
v March 31. Paid 175 for electric bill for the month
v March 31. Received 1870 from sales of service
v March 31. Make sales on account for 1,675.
v March 31. Hill withdrew 1500 for her personal use
v March 31. Recorded depreciation on photographic equipment @ 1%
, answer the questions below.
v Pass Adjusting entry
v Prepare financial statements
Which of the following is not regarded as a management task of a politician?
1. The following assets were invested in the enterprise; cash, 3500, accounts Receivable 950 supplies 1200; and photographic equipment 15000. There were no liabilities transferred to the business.
v March 1. Paid 2400 on for 3 moths office rent
v March 4. Purchased photographic equipment on account for 2500
v March 5. Received 850 from credit customers
v March 6. Paid 125 for advertisement( Miscell.exp)
v March 10. Paid 500 to settle March 4 debt
v March 13. Paid 575 for two weeks’ salary
v March 16. Received 1,980 from sale of service
v March 20. Paid 650 for supplies purchase
v March 27. Paid 575 for two weeks’ salary
v March 31. Paid 69 for telephone bill for the month
v March 31. Paid 175 for electric bill for the month
v March 31. Received 1870 from sales of service
v March 31. Make sales on account for 1,675.
v March 31. Hill withdrew 1500 for her personal use
v March 31. Recorded depreciation on photographic equipment @ 1
answer the questions below.
v Post transaction
v Prepare trial Balance
ACME Green is a huge, strategic project across all the companies in the ACME Technologies group.
Tshepo knows that technology will not be the only aspect he will need to manage well for the
project to be successful – he also needs the right people.
List five types of users that would be using the operational carbon accounting database and
explain what the responsibility of each type of user will be in ACME Technologies.
Problem Statement: You work in XYZ Corporation as a Data Analyst. Your corporation has told you to visualize the mtcars.csv dataset with various plots.
1. Plot the area chart for the colmns: ‘am’ and ‘carb’.
a. Set the ‘am’ on the x-axis.
b. Set the ‘carb’ on the y-axis.
c. Provide the x-axis label as Transmission.
d. Provide the y-axis labe as Number of carburetors.
e. Provide the title as Transmission vs Number of carburetors.
Problem Statement: You work in XYZ Corporation as a Data Analyst. Your corporation has told you to analyze the customer_churn dataset with various functions.
1. Now from the churn data frame, try to sort the data by the tenure column according to the descending order.
2. Fetch all the records that are satisfying the following condition:
a. Tenure>50 and the gender as ‘Female’.
b. Gender as ‘Male’ and SeniorCitizen as 0.
c. TechSupport as ‘Yes’ and Churn as ‘No’.
d. Contract type as ‘Month-to-month’ and Churn as‘Yes’
Problem Statement: You work in XYZ Corporation as a Data Analyst. Your corporation has told you to analyze the customer_churn dataset with various functions
1. Now select the rows from 20th index till 200th index (exclusive), and columns from 2nd index till 15th index value
Problem Statement: You work in XYZ Corporation as a Data Analyst. Your corporation has told you to analyze the customer_churn dataset with various functions.
1. Display the top 100 records from the original data frame.
2. Display the last 10 records from the data frame.
3. Display the last record from the data frame
3.Create a function that concatenates two dataframes. Use previously created function to create two dataframes and pass them as parameters Make sure that the indexes are reset before returning:
4. Write code to load data from cars.csv into a dataframe and print its details. Details like: 'count', 'mean', 'std', 'min', '25%', '50%', '75%', 'max'.
5. Write a method that will take a column name as argument and return the name of the column with which the given column has the highest correlation. The data to be used is the cars dataset. The returned value should not the column named that was passed as the parameters.
E.G: get_max_correlated_column('mpg')
-> should return 'drat'
Problem Statement:
You work in XYZ Company as a Python. The company officials want you to build a python program.
1. Write a function that takes start and end of a range returns a Pandas series object containing numbers within that range. In case the user does not pass start or end or both they should default to 1 and 10 respectively. eg. range_series()
-> Should Return a pandas series from 1 to 10 range_series(5)
-> Should Return a pandas series from 5 to 10 range_series(5, 10)
-> Should Return a pandas series from 5 to 10.
2. Create a function that takes in two lists named keys and values as arguments. Keys would be strings and contain n string values. Values would be a list containing n lists.
The methods should return a new pandas dataframe with keys as column names and values as their corresponding values e.g.
-> create_dataframe(["One", "Two"], [["X", "Y"], ["A", "B"]]) -
> should return a dataframe One Two 0 X A 1 Y B
Let fn(x)= x^n is not uniformly continuous on [0,1] but is uniformly continuous on [0,k]
a)
An increase in the ionisation of a molecule in a GI environment will usually
increase its solubility. Valproic acid is an oral dosage form used in epilepsy and
has a pKa of 4.8. With the stomach pH at 2.0 and the ileum at pH 6.8, which area
of the GIT will Valproic acid be more soluble.
b)
You are required to manufacture 1L of 50mM pH 7.0 phosphate buffer that could be
used for an injectable formulation of valproic acid. The Ka of dihydrogen phosphate is
6.3x10
-8
and the RMM of potassium dihydrogen phosphate and dipotassium
hydrogen phosphate are 136 and 174 respectively.
I.
Calculate the pKa of dihydrogen phosphate.
II.
What is the ratio between the conjugate base and the acid to be used?
III.
Calculate the mass of anhydrous potassium dihydrogen phosphate and
dipotassium hydrogen phosphate with RMM of 136 and 174, and
concentrations of 30.5 and 19.5 mmol respectively.
