Question: PLEASE ANSWER WITHIN PYSPARK I have a pyspark dataframe called Data I want to know how to replace 0 values in a column with the

PLEASE ANSWER WITHIN PYSPARK

I have a pyspark dataframe called Data

I want to know how to replace 0 values in a column with the average of said column

Say a column of numbers "Numbers" has 14 rows in the dataframe Data

Numbers
12
18
0
24
0
72
0
19
22
0
26
11
23
0

I want to take the average of this column and replace the '0' values with that average.

How would I do this?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

PLEASE ANSWER THE QUESTIONS IN THE LAST PHOTO. THANKS! BALANCING VALUES: AN INDIAN PERSPECTIVE ON CORPORATE VALUES FROM SCANDINAVIA By Martine Cardel Gertsen and Mette Zolner ACT 1 Bangalore, 17...

Q:

please answer the questions in last picture by reading above data in 250 words ASAP When I hear businessmen speak eloquently about the "social responsibilities of business in a free-enterprise...

Q:

Week 1 Lecture 1 Class Approach to Statistics Statistics is basically a set of tools that allow us to get information out of data sets (we will get to the more formal definition below). As such, it...

Q:

During the depression of the 1930s, Ben Jenkins, Sr., a wealthy, expansion-oriented lumberman whose family had been in the lumber business in the southeaster United States for several generations,...

Q:

CLOSING ARGUMENTS A Closing Argument should: 1. Repeat your theory and theme of the case 2. Summarize the evidence that preceded it 3. Relate the evidence to the law and the legal issues (i.e....

Q:

Hello. Can you help with this four question problem? Case PRIVATE EQUITY CASE: MERGER CONSOLIDATION The questions below COMBINE the Ohio & Maryland PT acquisitions as if they are a single c Learning...

Q:

ID Salary 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 65.1 27 36.1 61.4 46.6 73.3 39.7 23.2 74.6 22.8 23.4 62 40.7 23 24 51.1...

Q:

This case will use an Excel Workbook as a Tutorial Tool (with learning content incorprated into each worksheet). Within the Workbook there will be multiple worksheets that the student will need to...

Q:

CLOSING ARGUMENTS A Closing Argument should: 1. Repeat your theory and theme of the case 2. Summarize the evidence that preceded it 3. Relate the evidence to the law and the legal issues (i.e....

Q:

Set Student Name: 1. Describe the relationship between two variables that have a correlation coefficient value: a. Near -1 b. Near 0 c. Near 1 2. Data was collected where a weightlifter was asked to...

Q:

Here are the grades of all 25 students in a statistics class on their first test: 79 81 80 77 73 83 74 93 78 80 75 67 73 77 83 86 90 79 85 83 89 84 82 77 72 What is the z-score for a grade of 87?

Q:

American consumers comfortable using their credit cards to make purchases over the Internet? Suppose that a noted authority suggests that credit cards will be firmly established on the Internet once...

Q:

Blast Corporation manufactures purses and makeminus up kits. The corporation decides to quit manufacturing purses and distributes the assets associated with this division to its shareholders. The...

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

14-5 How much does project management impact the success of a new information system?

Q:

14-8 The U.S. Census launched an IT project to arm its census takers in the field with high-tech handheld devices that would save taxpayer money by directly beaming population data to headquarters...

Q:

14-10 This project provides you with an opportunity to use spreadsheet software to use the capital budgeting models discussed in this chapter and its Learning Tracks to analyze the return on an...