jan | Purely functional programming language | Functional Programming library

Dataset looks like this : This is a sample dataset for number of employee login activity named - activity

I need to calculate few metrics, was able to do in python data frames, but new in mySQL.

1. what is the average number of employee active per day for month of jan 2018 by dept ( was able to do somewhat half of it, but results coming are not correct.

2. number of unique active employee (login >0) per month for jan 2018 for each dept_id (was able to do it)

3. month over month growth for all dept_id from dec-2017 to jan 2018 where at least one employee was active (login >0) - no idea how to do this in sql

4. fraction of users who were active in each dept_id for dec 2017 and were also active in the same dept_id for jan 2018

5. how many employee login in on 3 or more consecutive days in jan 2018

Any help would be appreciated.

Query written for case 1:

I am having a dataset which contains the absolute HIV cases of four US State over 2 years.

There are three columns date (Jan 2018, Feb 2018 ...) , state (CA, NY, FL, MA) , and abs_cases in the data frame. I am ignoring the population changes in those 2 years in the respective states.

I now want to calculate the relative cases for each state using the population for each state which I googled. (I will just use fantasy numbers here) pop<- "CA"= 11111, "NY"= 22222, "FL"= 33333,"MA"= 444444.

I already tried using

I thought with the c# call:

I know there are some other questions (with answers) to this topic. But no of these was helpful for me.

I have a postfix server (postfix 3.4.14 on debian 10) with following configuration (only the interesting section):

If I log a timestamp in a NodeJS app, which I'm trying to split out of PG I can see: "2020-01-01T11:58:00.000Z" If I attempt to overcome a situation where I cannot split that where the error is .split is not a function. by doing either + '', or .toString() I get: Wed Jan 01 2020 05:58:00 GMT-0600 (Central Standard Time)

While I can still get to the numbers I'm seeking doing things that way I strongly feel there has to be a better way!? I can wrap the value in new Date() and use getMinutes() and getSeconds() I get the correct value. However, using getHours() returns a 5 for the aforementioned datetime value.

I THOUGHT doing the following would suffice to get all the parts I wanted, but again, split is not a function:

I was wondering how to make a query where I can select data from Jan 1, 21 to last week. I tried to put it in the date filter like this:

I needed help to convert below R dataframe. Can anyone can help me to do it? I tried

df:

I have a dataframe (all5) including one column with dates('CREATIE_DATUM'). Sometimes the notation is 01/JAN/2015 sometimes it's written as 01-JAN-15. I only need the year, so I wrote the following code line:

all5[['Day','Month','Year']]=all5['CREATIE_DATUM'].str.split('-/',expand=True)

but I get the following error:

columns must be same length as key

so I assume somewhere in my dataframe (>100.000 lines) a value has more than two '/' signs. How can I make my code skip this line?

my python file in which I work is contained in the following path '/Users/pycar/Documents/Srett/Python/', In this same space I have a folder that contains 8 other folders that all contain a csv that I want to import via panda because it's a database, the problem is that most of the codes found do not work (It says that the file is named 'month' and that the 8 folders are named by the first 8 months of the year then it does not matter what the names of the csv inside.

I would like to make a loop that digs into 'month' and goes into each folder (so january february etc...) and import the csv that is contained inside (with a read.csv).

for a little more visibility tell you that the file my_python is my notebook and that it is in the same folder as month which contains what I gave you

my_python

month-> january -> jan.csv

month-> February -> feb.csv

month-> March -> mar.csv

month-> April -> apr.csv

month-> May -> may.csv

month-> June -> jun.csv

month-> july -> jul.csv

month-> August -> Aug.csv

How can i proceed ?