Wednesday, November 30, 2022

binary search tree

In computer science, a binary search tree (BST), also called an ordered or sorted binary tree, is a rooted binary tree data structure with the key of each internal node being greater than all the keys in the respective node's left subtree and less than the ones in its right subtree. Wikipedia

Books for Learning


Chapters on Binary Search Tree and Microprocessor-Microcontroller

Binary Search Tree (BST) is a node-based binary tree data structure. It is one of the most widely used techniques for searching in non-linear data structure. Microprocessor and Microcontroller is a part of computer that plays an important role in today's technology. Reading these chapters will equip the readers with a summarized understanding of Binary Search Tree (BST) using C-Language and current trends on Microprocessor and Microcontroller

Advanced Algorithms and Data Structure

Advanced Algorithms and Data Structures introduces a collection of algorithms for complex programming challenges in data analysis, machine learning, and graph computing

Algorithms on Strings, Trees, and Sequences: Computer Science and Computational Biology

Traditionally an area of study in computer science, string algorithms have, in recent years, become an increasingly important part of biology, particularly genetics. This volume is a comprehensive look at computer algorithms for string processing. In addition to pure computer science, Gusfield adds extensive discussions on biological problems that are cast as string problems and on methods developed to solve them. This text emphasizes the fundamental ideas and techniques central to today's applications. New approaches to this complex material simplify methods that up to now have been for the specialist alone. With over 400 exercises to reinforce the material and develop additional topics, the book is suitable as a text for graduate or advanced undergraduate students in computer science, computational biology, or bio-informatic


Tuesday, November 29, 2022

auto click mac

Giguid USB Mouse Jiggler Undetectable Auto Clicker RGB Switchable with ON/Off Button Mouse Mover Plug & Play (ROBYMICE Series, 1 Item)


About this item
  • Tiny powerful smart chip with high-tech alien face, make all the difference.
  • Built in power saving LED indicator, can be turned off manually or automatically in standby.
  • 7 light color options with memory function, breathe softly while moving, flicker softly while click.
  • Make cursor moves randomly, or switch to automatically click 2 times per second on the target location.
  • Plug and Play, no driver needed, no software installation required, easy and simple.
  • USB Type-A connector can plug into any USB 1.0, USB 2.0, USB 3.0 port on the computer.
  • Compatible with popular desk PC and laptops, like Windows, Mac, Linux, Android, Chrome.
  • 1 year warranty with no reason to exchange, just feel free to contact us if there's any problem.


Sunday, November 27, 2022

Should you Learn VBA or Power Query?


Should you Learn VBA or Power Query? Data Analytics and Business Analytics is quiet making some attention lately. It's a not new subject or system. Instead a very interesting approach and drives demands in the industry.

But the core of this two sciences (if I'm attributing them correctly) is of course Data and the Efficiency in managing the models. Speaking of efficiency is of course Automation ( to some degree if not totally ).

VBA

Visual Basic for Application is a legacy platform and it's been in existence, like ever since. It's a staple, comfort tools to some office productivity tools developers out there. Many applications have been build around it. It offered some relief to some office suite automation requirements. Very effective, but some find it hard for it needs programming skills to be able to build. Though there's Macro Recording, in Microsoft Excel, it really comes in handy.

Yet, just like any other technology new comes along, offers alternative and no coding involved.


Power Query

"Data prep done smart, fast, easy. Power Query is the easiest way to connect, extract, transform and load data from a wide range of sources" ---https://powerquery.microsoft.com/en-us/

ETL - Extract, Transform and Load are three basic steps for data usage and application. Most of the time in repetition and with repetition needs automation. In power query this is a guided steps and no coding involved. Every steps recorded instantaneously with less worry of maintaining a code base. We can say, like a Macro Recorder in a way that you can rearrange your steps without going into the actual codes. Convenient it is.


What's the verdict?

Data manipulation, cleansing or modelling. Power Query can be a very potent tool specially if we're dealing with large sets. It can also, deal a multitude of data sources. Local or online data streams. 

Automation and Repetition, both VBA and Power Query can efficiently offer. But, VBA can give level of customization with your applications. Specially with User Interaction, tapping other applications and just simply doing thing the other way.

So which should you choose?