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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Databases And Information Systems 1 International Baltic Conference Dbandis 2020 Tallinn Estonia June 19 2020 Proceedings
Authors: Tarmo Robal ,Hele-Mai Haav ,Jaan Penjam ,Raimundas Matulevicius
1st Edition
303057671X, 978-3030576714
