What is the most popular package in Ireland

Assignment Help Python Programming
Reference no: EM133180768

Big Data Management

Questions

You answer the same questions as in assignment 1 but this time you are required to use the SQL API of Apache Spark. Prepare Cassandra structures and Spark code that saves the precomputed data into these structures:

1. Show number of downloads for package ggplot2.

2. Highest number of downloads by a country. Show its name.

3. Top 10 smallest sized packages.

4. What are the top 10 least popular packages?

5. Highest number of downloads by an Operating System.

6. What is the most popular package in Ireland?

7. What is the highest number of downloads by a single machine?

8. What OS is the least popular among the R programmers?

9. How many users use MAC OS?

10. List total number of incomplete records - lines which have missing values.

Task 1

For your first task, you are required to use Apache Spark RDD's transformations and actions to answer above questions about the dataset.

Task 2

In this task you are required to use Apache Spark's SQL API to to answer above questions about the dataset. Store the results for each question in Apache Cassandra.

Task 3

In the last task, you are required to use Apache Spark's Streaming API to compute the real-time views for the questions. For storing these views you need to use the Apache Cassandra. To emulate a live-stream of the download logs, you are required to write a separate Python script that reads 1000 lines every 5 seconds from each log file and stores them as separate files (log1, log2, log3, etc.) in the streaming directory on which your application is listening.

Submission
• Submit your solution on Moodle by the specified deadline.
• Acceptable file format: Python notebook - name it student name.ipynb. The notebook should be exported as iPython Notebook with *.ipynb extension. If the code in your notebook does not run, it will result in 20% penalty.

• Take two screenshots of your solution to each question (code + its output into the Cassandra table where applicable) and insert it in a word document, generate a pdf of this document.

Attachment:- Big Data Management.rar

Reference no: EM133180768

Questions Cloud

What is the minimum lease payment : What is the minimum lease payment that would make purchasing a precision manufacturing machine and writing a 4-year lease contract on it
Method of departmentalization : Draw the organization chart of this company. What is the method of departmentalization used at each level on the chart?
Promoting the health and safety of employees : What are the most significant challenges and how can employers bring a culture promoting the health and safety of their employees?
Compute the diluted earnings per share : During the current year, the entity paid dividends of P5 per share on the preference share. Compute the diluted earnings per share
What is the most popular package in Ireland : Use Apache Spark RDD's transformations and actions to answer above questions about the dataset - What is the most popular package in Ireland
Explain the range of diversity : Explain the range of diversity and the implications for educators in creating open and inclusive educational settings and examine how children and families from
Assignment on composite quality score : You work with Ritu Reddy in the Process Excellence Division. You have been tasked with assisting the leadership team of the lowest-ranked
Describe the understanding of required ergonomic practices : Describe the understanding of the required ergonomic practices by: - Adjusting your chair so that it is at the required height
Why does the balance sheet have to balance : Why does the balance sheet have to balance? In other words, why do total assets have to equal total liabilities and equity? Give an example

Reviews

Write a Review

Python Programming Questions & Answers

  Write a python program to implement the diff command

Without using the system() function to call any bash commands, write a python program that will implement a simple version of the diff command.

  Write a program for checking a circle

Write a program for checking a circle program must either print "is a circle: YES" or "is a circle: NO", appropriately.

  Prepare a python program

Prepare a Python program which evaluates how many stuck numbers there are in a range of integers. The range will be input as two command-line arguments.

  Python atm program to enter account number

Write a simple Python ATM program. Ask user to enter their account number, and print their initail balance. (Just make one up). Ask them if they wish to make deposit or withdrawal.

  Python function to calculate two roots

Write a Python function main() to calculate two roots. You must input a,b and c from keyboard, and then print two roots. Suppose the discriminant D= b2-4ac is positive.

  Design program that asks user to enter amount in python

IN Python Design a program that asks the user to enter the amount that he or she has budget in a month. A loop should then prompt the user to enter his or her expenses for the month.

  Write python program which imports three dictionaries

Write a Python program called hours.py which imports three dictionaries, and uses the data in them to calculate how many hours each person has spent in the lab.

  Write python program to create factors of numbers

Write down a python program which takes two numbers and creates the factors of both numbers and displays the greatest common factor.

  Email spam filter

Analyze the emails and predict whether the mail is a spam or not a spam - Create a training file and copy the text of several mails and spams in to it And create a test set identical to the training set but with different examples.

  Improve the readability and structural design of the code

Improve the readability and structural design of the code by improving the function names, variables, and loops, as well as whitespace. Move functions close to related functions or blocks of code related to your organised code.

  Create a simple and responsive gui

Please use primarily PHP or Python to solve the exercise and create a simple and responsive GUI, using HTML, CSS and JavaScript.Do not use a database.

  The program is to print the time

The program is to print the time in seconds that the iterative version takes, the time in seconds that the recursive version takes, and the difference between the times.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd