Ping World

Map the world!

Notebook: Apache Spark thoughts

""

This is a notebook of some thoughts when I played with Spark, thought this might be a good way to share. GroupByKey VS ReduceByKey VS AggregateByKey VS CombineByKey GroupByKey: group ...

Tableau


Gloabl flights

Kepler.gl embedded map ...

Number of Islands

"Algorithms"

Description Given a 2d grid map of '1's (land) and '0's (water), count the number of islands. An island is surrounded by water and is formed by connecting adjacent lands horizontally or vertically....

Merge Two Sorted Lists

"Algorithms"

Description Merge two sorted linked lists and return it as a new list. The new list should be made by splicing together the nodes of the first two lists. Example: 1 2 Input: 1->2->4, 1->...

Remove Nth Node From End of List

"Algorithms"

Description Given a linked list, remove the n-th node from the end of list and return its head. Example: 1 2 3 Given linked list: 1->2->3->4->5, and n = 2. After removing the secon...

Intersection of Two Linked Lists

"Algorithms"

Description Write a program to find the node at which the intersection of two singly linked lists begins. For example, the following two linked lists: Example 1: 1 2 3 Input: intersectVal = ...

Add Two Numbers

"Algorithms"

Description You are given two non-empty linked lists representing two non-negative integers. The digits are stored in reverse order and each of their nodes contain a single digit. Add the two numbe...

Notebook: SQL Antipatterns

""

This is a notebook including what I have learned and summarized from the famous book <SQL Antipatterns>. Logical Database Design Antipatterns Jaywalking Definition: In a Many-To-Many s...

Linked List Cycle

"Algorithms"

Description Given a linked list, determine if it has a cycle in it. To represent a cycle in the given linked list, we use an integer pos which represents the position (0-indexed) in the linked lis...