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 All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP, SolveDir