AnswerBun.com

Merge Two Files in Weka based on date

Stack Overflow Asked by spwath on December 4, 2020

I have two datasets I want to merge together, with different attributes. One has about 4 million instances, the other has about 180.
They both have date attributes, and cover the same time period. The one with 4 million has a date attribute that covers day/month/year and time. The other one only has day/month/year. How can I merge these and have the smaller dataset copy its instances to every instance of the larger dataset, for that day?

One Answer

As far as I know Weka, what you want to do will be a nightmare. It's better if you try it on a programming language like R or Python. I would suggest you to try it on Excel, if your big dataset didn't have 4 million entries. The easiest way to do that is with Python Language and more specifically Pandas package.

Answered by Mighty Diffy on December 4, 2020

Add your own answers!

Related Questions

Python, change a var by a string

4  Asked on February 21, 2021 by beardlongo

   

Vue – how to show an array of data in a table?

2  Asked on February 21, 2021 by jayk23

     

CMake unit testing – Unresolved external symbol

1  Asked on February 21, 2021 by chrispytoes

   

Break string into new rows after grepl

2  Asked on February 21, 2021 by ip2018

   

Send unicode sms with java

3  Asked on February 21, 2021 by hong4rc

     

Getting n1 n2 outputs after conversion

2  Asked on February 21, 2021 by icemilo

   

Is that possible to make for each user table in database

0  Asked on February 21, 2021 by haddadi-abdraouf

     

Run-time Error 1004; Error handling

2  Asked on February 20, 2021 by karl-drews

       

Password Generating program in python

2  Asked on February 20, 2021 by m-ismail

         

Error TS1086:An accessor cannot be declared in an ambient context

0  Asked on February 20, 2021 by leonardokunkel

 

Pass object data as FormData

2  Asked on February 20, 2021 by swarup-chavan

   

Iteration in Python throws results no desired

1  Asked on February 20, 2021 by catalina-hernndez

         

Ask a Question

Get help from others!

© 2022 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP, SolveDir