Assume that a file called invoiceDF is created in Spark shell. CallinginvoiceDF.printSchema () returns the following output:root|--InvoiceNo: string (nullable = true)|-- StockCode: string (nullable = true)|-- Description: string (nullable = true)-- Quantity: integer (nullable = true)|-- InvoiceTimestamp: timestamp (nullable = true)|-- UnitPrice: double (nullable = true)|-- CustomerID: double (nullable = true)|-- Region: string (nullable = true)Present the Scala source code to implement the following queries on invoiceDF: (a) returnthe total number of rows, (b) return the number of unique stock codes, (c) return the averageunit price per stock code and (d) returning the number of invoices per customer ID.

According to guidelines solve first three: Here i am writing query: 1.for total number of rows,…

invoiceDF.printSchema () returns the following output: root |--InvoiceNo: string (nullable = true) |-- StockCode: string (nullable = true) |-- Description: string (nullable = true) |-- Quantity: integer (nullable = true) |-- InvoiceTimestamp: timestamp (nullable = true) 1 UnitPrice: double (nullable = true) |-- CustomerID: double (nullable = true) |--Region: string (nullable = true) Present the Scala source code to implement the following queries on invoiceDF: (a) return the total number of rows, (b) return the number of unique stock codes, (c) return the average unit price per stock code and (d) returning the number of invoices per customer ID.

invoiceDF.printSchema () returns the following output: root |--InvoiceNo: string (nullable = true) |-- StockCode: string (nullable = true) |-- Description: string (nullable = true) |-- Quantity: integer (nullable = true) |-- InvoiceTimestamp: timestamp (nullable = true) 1 UnitPrice: double (nullable = true) |-- CustomerID: double (nullable = true) |--Region: string (nullable = true) Present the Scala source code to implement the following queries on invoiceDF: (a) return the total number of rows, (b) return the number of unique stock codes, (c) return the average unit price per stock code and (d) returning the number of invoices per customer ID.

Microsoft Visual C#

7th Edition

ISBN:9781337102100

Author:Joyce, Farrell.

Publisher:Joyce, Farrell.

Chapter11: Exception Handling

Section: Chapter Questions

Problem 4E

See similar textbooks

Similar questions

you must create the data files with a text tool, such as Notepad exampleThree In the while loop, this program reads fileLoop.txt until all items are read package hasnext; import java.util.Scanner; import java.io.*; // public class Hasnext { public static void main(String[] args) throws IOException { File loopfile = new File("fileLoop.txt"); Scanner getAll = new Scanner( loopfile ); // connect a Scanner to the file int num = 0, square = 0; while(getAll.hasNextInt()) { num = getAll.nextInt(); square = num * num ; System.out.println("The square of " + num + " is " + square); } getAll.close(); } }
Can you please write in Scanner form and can you please make so i can copy and past it Write a class FileConverter with a constructor that accepts a String file name as its argument. It should store filename as its attribute (with a accessor getFilename()).The class should have the following methods:• createUpperCaseFile(): Accepts a String parameter targetFilename. It will open up both the file specified in class attribute filename and the method parameter targetFilename. Then it will convert all lines of the class attribute filename to upper case and write it to target file, line by line.• createRowCharCountFile(): Accepts a String parameter targetFilename. It will open up both the file specified in class attribute filename and the method parameter targetFilename. Then it will count the number of chars in each line of the class attribute filename and write it to target file line by line. The class must come with a main() method, which will create an object instance and generate…
This is for Java. Please help. Thanks
Write an application that displays the sizes of the files lyric1.txt and lyric2.txt in bytes as well as the ratio of their sizes to each other. Here is the code so far: import java.nio.file.*; import java.nio.file.attribute.*; import java.io.IOException; public class FileSizeComparison { public static void main(String[] args) { Path textFile = Paths.get("/root/sandbox/lyric1.txt"); Path wordFile = Paths.get("/root/sandbox/lyric2.txt"); // Write your code here } }
create a class named FileUtils. Add a method static void copyFile(String source, String destination) method that copies the source file to the destination location. For example, if called as copyFile(“a.txt”, “b.txt”) the contents of the file “a.txt” would be copied into the file “b.txt.”a. You must write the code to copy the file using java.io.* classes (e.g. File, FileInputStream, FileOutputStream, etc.).b. Do not assume that the files will contain only text.c. You should try to copy efficiently (i.e. not a single byte at a time).d. It is suggested that you test your method by copying the provided files from the input directory to the output directory in your project.e. The method should rethrow any exceptions that may occur.
in java' Variables fStream and dataFS are FileInputStream and Scanner, respectively. String fileName is assigned a file's name read from input. Perform the following tasks: Assign fStream with a FileInputStream that opens the file fileName for reading. Assign dataFS with a Scanner created using fStream. Click here for example Ex: If the input is peach2.txt and: Data in file peach2.txt 4.3 then the output is: 4.3 GroceryDataProcessor.java peach1.txt peach2.txt peach3.txt public class GroceryDataProcessor { publicstaticvoidmain(String[] args) throwsIOException { Scannerscnr=newScanner(System.in); StringfileName; doublepeachWeight; FileInputStreamfStream=null; ScannerdataFS=null; fileName=scnr.next(); /* Your code goes here */ peachWeight=dataFS.nextDouble(); System.out.println(peachWeight); fStream.close(); } }
Create a file named Question.py and then create a class on it named Question. A Question object will contain information about a trivia question. It should have the following: A constructor, with the following parameters: 1 string to be the question itself (for example: "When was Cypress College Founded?"). A list of four strings, each a possible answer to the question (only one of them should be correct) An integer named 'answer': the index in the list of the correct answer. Example: if the third answer in the answer list is the correct one, the client should pass 2 to this parameter to signify the correct answer is in index 2. Overload the __str__ method. It should return a string made up of the question and the four possible answers. A ‘guess’ method, with an integer parameter. If the 'answer' attribute matches the int passed to 'guess', return True. Otherwise, False On Main.py, in your main function, create a list and add four Question objects to it. You may give them with…
You are required to develop a small chatting application where two or more friends can communicate each other through messages. Create a class Message which has Date date, and message (string). Provide getters/setters, constructors, toString. Create a class Friend having String name, String contact, email provide getters/setters, constructors, toString. Provide following options to the user. Add Friend (which add new friend to the Friends file) View Friends (read data from Friends file and display) Send message(This should ask for friend name and message match the friend name and write that message to the inbox file). Read messages (This show all messages form inbox on JList or Text area. Note:Create a manager class with methods use to read and write messages to “inbox” file you should write sentMessage(Friend f,Message message) method which write the messages to the file user can send as many message as he/she wants (use loop and arraylist). Write another method readMessages()…
Build a csharp application that reads from a file and print out the contents of that file in another files words by words (i.e. one word each line)
Language/Type: Related Links: Author: Java file input Scanner Nick Troccoli (on 2017/04/25) Write a method named classPresidents that tallies votes for presidents of two school classes. Somehow the vote tallies for sophomore and junior class presidents got mixed up! Your method should accept as its parameter a Scanner representing a file of vote results. It should output the next sophomore and junior class presidents. The file format looks like the following: Jared s 25 Sophie j 12 Tom j 44 Isaac s 30 Emily s 60 Russ s 23 Madison j 20 The file repeats the pattern name year votes. The year is either "s" for sophomore or "j" for junior. Your program should output the candidate in each presidential race with the most votes, and how many votes they got. Specifically, if this file were named candidates.txt, your method could be called in the following way: Scanner input new Scanner (new File("candidates.txt")); classPresidents (input); The above call should produce the following output:…
You are given a text file (Words.txt) containing 50 words that will be hard to make out because they have been littered with punctuation. Your task is to: • Create a new file called Words2.txt, from Words.txt, which contains all the strings from the previous file, with their position, but with all the punctuation removed. (You must create some sort of method that can loop through the words to do this, you are not allowed to use Regex Patterns) Hint: This might come in handy String punctuation = "!\"#$%&'()*+,-./:;<=>?@[\\]^_`{|}~"; • You must find the first longest word that appears in the text file with their position retained as well as indicating the number of characters therein, the formatting for this can be seen in Table 1.
ExampleTwo This program loops through fileLoop.txt, computation, and display results package charioloop; import java.util.Scanner; import java.io.*; // public class Charioloop { public static void main(String[] args) throws IOException { //Create a reference to the physical file File loopfile = new File("fileLoop.txt"); // connect a Scanner to the file Scanner getAll = new Scanner( loopfile ); int num = 0, square = 0; while(num != -1){ num = getAll.nextInt(); square = num * num ; System.out.println("The square of " + num + " is " + square); } getAll.close(); } } /* Create fileLoop.txt in I:\\Ajava\161\WPPractice\IO\charstream\charioloop My fileLoop.txt looks like this: 2 3\ 2 10 -1 Note:- Study this program and follow the given instruction and execute type the code and provide also output for this java program as soon as possible.