BJ Data Tech Solution

Specialized on Data processing, Data management Implementation plan, Data Collection tools - electronic and paper base, Data cleaning specifications, Data extraction, Data transformation, Data load, Analytical Datasets, and Data analysis. BJ Data Tech Solutions teaches on design and developing Electronic Data Collection Tools using CSPro, and STATA commands for data manipulation. Setting up Data Management systems using modern data technologies such as Relational Databases, C#, PHP and Android.

How to replace missing observations with the weighted sum of other observations
How to replace missing observations with the weighted sum of other observations

Hello All,

I am currently working with a panel data-set where I have missing observations for every column excluding Year and GeoName. I have attached a screenshot for reference.

My objective is to replace my missing observations with the weighted sum of other observations. For example, I would like to replace the missing values in Ethanol_cap21 with .118 * the value given for the District of Columbia + .129 * the value given for Nevada + etc.

I apologize if my question is a little vague. I can happily provide extra information if needed.

Thanks,

Mitchell

BJ Data Tech Solution

Home / Data Cleaning / Data management / Data Processing / How to replace missing observations with the weighted sum of other observations
How to replace missing observations with the weighted sum of other observations

0 Response to How to replace missing observations with the weighted sum of other observations

Post a Comment

Home / Data Cleaning / Data management / Data Processing / How to replace missing observations with the weighted sum of other observations How to replace missing observations with the weighted sum of other observations

0 Response to How to replace missing observations with the weighted sum of other observations