Categories
User Help

How come I can’t print this custom excel slide range?

So, I basically wanted to print a range of slides. I have about 800 slides in one PowerPoint and I wanted to print out every other slide, so I made the following numbers separated by a comma using Microsoft Excel: 1,3,5,7,9,11,13,15,17,19,21,23,25,27,29,31,33,35,37,39,41,43,45,47,49,51,53,55,57,59,61,63,65,67,69,71,73,75,77,79,81,83,85,87,89,91,93,95,97,99,101,103,105,107,109,111,113,115,117,119,121,123,125,127,129,131,133,135,137,139,141,143,145,147,149,151,153,155,157,159,161,163,165,167,169,171,173,175,177,179,181,183,185,187,189,191,193,195,197,199,201,203,205,207,209,211,213,215,217,219,221,223,225,227,229,231,233,235,237,239,241,243,245,247,249,251,253,255,257,259,261,263,265,267,269,271,273,275,277,279,281,283,285,287,289,291,293,295,297,299,301,303,305,307,309,311,313,315,317,319,321,323,325,327,329,331,333,335,337,339,341,343,345,347,349,351,353,355,357,359,361,363,365,367,369,371,373,375,377,379,381,383,385,387,389,391,393,395,397,399,401,403,405,407,409,411,413,415,417,419,421,423,425,427,429,431,433,435,437,439,441,443,445,447,449,451,453,455,457,459,461,463,465,467,469,471,473,475,477,479,481,483,485,487,489,491,493,495,497,499,501,503,505,507,509,511,513,515,517,519,521,523,525,527,529,531,533,535,537,539,541,543,545,547,549,551,553,555,557,559,561,563,565,567,569,571,573,575,577,579,581,583,585,587,589,591,593,595,597,599,601,603,605,607,609,611,613,615,617,619,621,623,625,627,629,631,633,635,637,639,641,643,645,647,649,651,653,655,657,659,661,663,665,667,669,671,673,675,677,679,681,683,685,687,689,691,693,695,697,699,701,703,705,707,709,711,713,715,717,719,721,723,725,727,729,731,733,735,737,739,741,743,745,747,749,751,753,755,757,759,761,763,765,767,769,771,773,775,777,779,781 The problem is it will only print out if I used all the numbers […]

Categories
Mastering Development

How to calculate the time spent at location for each unique ID per day?

I’m currently working on the smartGPA dataset (https://studentlife.cs.dartmouth.edu/smartgpa.pdf) and I was trying to calculate the time spend studying at a location at each day for each student (UID) to eventually get a mean study time for each student. I have timestamp data and location data for each student based on wifi location data. For example, […]

Categories
Mastering Development

simple list comprehension question python

list=(1,2,3,4) for x in range(len(list)): print(list[x]) 1 2 3 4 but print(list) repeats the whole list 4 times ie 1,2,3,4 1,2,3,4 1,2,3,4 how does the x in the print(list[x]) cause only single numbers to come out? Like how could you put what the [x] is doing in english?

Categories
Mastering Development

SQLite query that returns aggregated column ordered by decreasing reserved tickets

Create table plays ( id integer not null, title varchar(40) not null, writer varchar(40) not null, unique(id) ); create table reservations ( id integer not null play_id integer not null, number_of_tickets integer not null, theater varchar(40) not null, unique(id) ); The query should count the number of reserved tickets for each play. The results should […]

Categories
Mastering Development

How can I calculate weighted standard errors and plot them in a bar plot?

I have a data frame of counts. I would like to calculate weighted proportions, plot the proportions, and also plot standard error bars for these weighted proportions. Sample of my data frame: head(df[1:4,]) badge year total b_1 b_2 b_3 b_4 b_5 b_6 b_7 b_8 b_9 b_10 1 15 2014 14 3 2 1 1 1 […]

Categories
Database Development

Index Order Help SQLite

I have a very large sqlite table (70 million rows) on a low end machine that I am trying to properly index. My columns are timestamp, machineid, ioid and value. There are probably about 200 ioids (on each machine), a handful of machineids and timestamp is one sample per second for each ioid. My queries […]

Categories
Mastering Development

How to style text annotation using CSS in highchart

I have below interactive plot using highchart js library with R library(highcharter) set.seed(100) Data = data.frame(x = round(rnorm(20) * 100, 2), y = round(rnorm(20) * 100, 2), z = letters[1:20]) hchart(Data, “scatter”, hcaes(x, y)) %>% hc_annotations(list(labelOptions = list(y = 35, x = 0, backgroundColor = ‘rgba(0, 0, 0, 0)’, borderColor = “rgba(0,0,0,0)”), labels = list(list(point […]

Categories
Mastering Development

Combining/Summing rows of a numy array based on a list of indices

I have an array where I would like to add specific rows together in order to get an array with less rows. import numpy as np a = np.arange(50).reshape(5,10) b = [0,0,0,1,1,2,2,2,2,3] a array([[ 0, 1, 2, 3, 4], [ 5, 6, 7, 8, 9], [10, 11, 12, 13, 14], [15, 16, 17, 18, 19], […]

Categories
Mastering Development

How adjust a moderated moderated mediation model with processR package?

I want adjust a moderated moderated mediation model with lavaan and processR packages. The model is follow: I tried to create the following moderations: Innovativeness:Age and PBC:Innovativeness:Age My data (df): df <- structure(list(Attitude = structure(c(33, 30, 37, 29, 36, 42, 27, 35, 35, 27, 22, 25, 42, 25, 38, 35, 38, 36, 34, 40), label […]

Categories
Mastering Development

Replace certain columns in a data frame with the columns of another data frame

I have two data frames with the same columns names and the same size. Each of them has 40 columns and 5000 rows. I would like to replace certain columns in a data frame with those from the other df arranged by their common ID. The column ID is identical for both dfs but not […]