brb | Interactive Brokers TWS API -- The Big Red Button | Cryptocurrency library

I need to plot the names of the countries that are present in my dataframe only, not all world countries. Any suggestions?

I have a dataset that shows bilateral exports for several countries. Because the data fluctuates, I need to calculate the mean of year groups. All the countries do not cover exactly the years. Some start later, some have gaps in between - this means, some years are missing (but without having NA entries). I already managed to cut the data into pieces whith the help of an amazing community member: year_group.

Below I am listing two further problems along with my code, the wrong output and on the bottom some sample input data for the dataset total_trade

Problem 1

I am facing the issue, that the code does not calculate the right means. When I calculate the results manually, I get different results than my code. (see below)

This is my code

I am trying to filter Countries, across the years 2000 to 2016, where indic.no must equal 10 across ALL years.

I have tried using different filtering using multiple conditions, but never seem to get the expected results.

I'm building a community website, I've made a timeline system (just like Facebook). People can post text, or create and post an event as a post (post type will be 'event').

I have the following tables:

Posts

id(pk), user_id, content, type, space, space_id, date, visibility

Users

id(pk), username, profile_photo, f_name, l_name

Likes

id(pk), post_id, user_id

Events

id(pk), title, visibility, event_type

I noticed that fetching 5 posts is taking 700ms, because I was getting the posts in one query, then I do all the other queries for each individual post inside the while-fetch loop(php). (a lot of SQL calls)

I want to get posts, the post owner(user), the post like count, and post event if post type is event, and this is what i came up with:

I have a dataframe with a column called "body" that consists of various length strings. I also have a dictionary of acronyms that looks something like this:

I´d like to get the more similar number within a list of numbers. In column A are some numbers and in column B a related code for that number. In column C are entries for which I want to find the most similar value and put output in column D showing the related product if possible. I hope make sense.

I show in colors the more similar "Short codes" for each entry.

My humble attempt is like below, I use Index and Match to find exact matches, but for closest matches I don't know how to start.

I like to have this using VBA since I´d apply it to values not in columns, but in an vba array for example.

So, i'm working with 3 different datasources in my application. Initially there were 2, but i had to add another one due to some project changes. After creating a model, a repository, a class to configure this new datasource i'm not able to start my application. It gives the error below:

I'm having real trouble with tinyMCE's textpattern plugin, which just simply doesn't appear to work. The code below is as basic as I can make it with an example taken directly from the tinyMCE website. But, if I type (c) (for-instance), and then press space or enter (as directed), nothing happens. I would expect tinyMCE to change it. What am I doing incorrectly?