taiwan | The Taiwan , TW of nodeschool

I've joined 2 tables and extract the top 2 vendors by country (code at the bottom of this post and link) with the help of Tim Biegeleisen on this link , now I would like to go 1 step further and group the top 2 vendors by year by country.

The original ORDERS table looks like this :

country_name date_local vendor_id gmv_local is_successful_order Taiwan 2012-10-02 2870 559.6 true Taiwan 2012-10-02 3812 573.5 true Singapore 2012-10-02 941 778.6 true Singapore 2014-10-02 13 120.6 true Bangkok 2014-10-02 227 563.6 true

This table is merged with the vendor table

id vendor_name country_name 2870 C House Taiwan 941 A House Singapore 227 9 House Bangkok

I would like to extract the year from the "date_local" column into timestamp format, where the items in the Year column will look like "2012-01-01T00:00:00" from the original date format of "2012-10-02"

Then I would like to list out the top 2 vendors of by year of each country in total revenue

The resulting table should look like this:

year country_name vendor_name total_gmv 2012-01-01T00:00:00 Singapore A House 1119.76 2012-01-01T00:00:00 Singapore B House 819.63 2012-01-01T00:00:00 Taiwan C House 119.6 2012-01-01T00:00:00 Taiwan D House 119.6 2012-01-01T00:00:00 Bangkok 9 House 119.6 2014-01-01T00:00:00 Singapore A House 2119.76 2014-01-01T00:00:00 Singapore B House 1819.63 2014-01-01T00:00:00 Taiwan C House 1019.6 2014-01-01T00:00:00 Taiwan D House 919.6 2014-01-01T00:00:00 Bangkok 9 House 189.6

printscreen of target results

I know I need to add one more partition of the Extract( year FROM date_local) as year and set it to the correct GETDATE() timestamp format to add the extra layer needed, but I don't know how to add it to the code

...

I would like the last field to have 50px border radius on the right. Why is this not working?

...

Here is the code:

...

I would need your help on this, as I'm not very good at regex expressions!

I want to split the following string at every second occurrence of "/"

...

I have an csv file of having data I want to convert into json format but I get issue about the formation.

Data input in csv file:

Data shown in Dataframe:

The data format I want in json:

...

There is a problem with my ggplot, I want to have different shapes for certain values. But in the legend all thing stack on top of each other and therefore the legend is not clear anymore. Moreover, I would like to delete Japan from the legend or find another way to make it red and shape=17. Maybe add to the filter Japan=='FALSE'? I tried but did not succeed...

Here is sample of my data:

...

I want to show autocomplete list inside slick slider , on typing country name , html is adding country hints in dropdown but it is not visible and is white , i am unable to find problem , u can check this by inspect that html is coming but not visible , why is dropdown not visible

...

I want to group the values from one column to another. My idea is to do new column ith continents. I have the lists witf countries. e.g Poland -> Europe, France ->

I have tried different methods, and every time I get in new column values ‘Other' or none. Can You help me?

...

I open a directory that has multiple subdirectories with names of countries. What i want is to make a list and store the paths of these directories in the nodes. The issue comes up when i print the list and in the destructor. I don't seem to get what's wrong since i've used these functions multiple times before with no issue coming up.

The directory looks something like this:

...