Tjyylli

What's the difference between 'rename' and 'mv'?

Why doesn't using multiple commands with a || or && conditional work?

Why was the shrinking from 8″ made only to 5.25″ and not smaller (4″ or less)?

Did Shadowfax go to Valinor?

What is the intuition behind short exact sequences of groups; in particular, what is the intuition behind group extensions?

If human space travel is limited by the G force vulnerability, is there a way to counter G forces?

What do you call someone who asks many questions?

How can I prevent hyper evolved versions of regular creatures from wiping out their cousins?

Why does Kotter return in Welcome Back Kotter?

Assassin's bullet with mercury

How could indestructible materials be used in power generation?

Watching something be written to a file live with tail

In Romance of the Three Kingdoms why do people still use bamboo sticks when paper had already been invented?

What is the word for reserving something for yourself before others do?

How can saying a song's name be a copyright violation?

1960's book about a plague that kills all white people

What is going on with Captain Marvel's blood colour?

Forgetting the musical notes while performing in concert

Alternative to sending password over mail?

Western buddy movie with a supernatural twist where a woman turns into an eagle at the end

Why doesn't H₄O²⁺ exist?

How can I make my BBEG immortal short of making them a Lich or Vampire?

What mechanic is there to disable a threat instead of killing it?

What does it mean to describe someone as a butt steak?

Structuring Multi-stage Project in R-SQL [on hold]

Display Project ProgressProject Management Tools like BaseCamp that integrate with SalesForce?Project planning with MS Project 2007Is there software to visualize project timeline data?Transpose data at particular row w python,r,sql?Creating tables in SQLSQL Code Error `Characters found after end of SQL statement`SQL Server Management Studio for sql server 2008Unable to connect to Microsoft SQL server from RStudioHow display sub project title on parent work package OpenProject

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}

0

I'm tasked with structuring a multi-stage project in R, which looks like this:

Intake (continuous) -> collect survey data (using API) -> add respondents to pool -> select respondents based on criteria -> produce graphical report output for selected respondents

I need to:

1. structure the API "intake" script to collect all new responses, on a daily basis


2. Process results, and add results to some kind of database (perhaps SQL but also may be a googlesheet) based upon criteria


3. Make a selection from those respondents, placing some in a secondary "pool" if they don't meet criteria


4. continue process, prioritzing respondents in secondary pool for selection

I have the analysis side down, more or less, and the reporting side, however the transfer between databases, ensuring there is no duplication, and no accounts get lost is definitely my biggest worry. Happy to describe further.

I'm currently looking at setting up a local SQL server on my machine, and using usethis for reporting results. Thanks for any guidance in project management on this topic.

sql google-spreadsheets r project-management rstudio

share|improve this question

asked 12 hours ago

Corey PembletonCorey Pembleton

11

New contributor

Corey Pembleton is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

put on hold as too broad by DavidPostill♦ 10 hours ago

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

add a comment | 

0

I'm tasked with structuring a multi-stage project in R, which looks like this:

Intake (continuous) -> collect survey data (using API) -> add respondents to pool -> select respondents based on criteria -> produce graphical report output for selected respondents

I need to:

1. structure the API "intake" script to collect all new responses, on a daily basis


2. Process results, and add results to some kind of database (perhaps SQL but also may be a googlesheet) based upon criteria


3. Make a selection from those respondents, placing some in a secondary "pool" if they don't meet criteria


4. continue process, prioritzing respondents in secondary pool for selection

I have the analysis side down, more or less, and the reporting side, however the transfer between databases, ensuring there is no duplication, and no accounts get lost is definitely my biggest worry. Happy to describe further.

I'm currently looking at setting up a local SQL server on my machine, and using usethis for reporting results. Thanks for any guidance in project management on this topic.

sql google-spreadsheets r project-management rstudio

share|improve this question

asked 12 hours ago

Corey PembletonCorey Pembleton

11

New contributor

Corey Pembleton is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

put on hold as too broad by DavidPostill♦ 10 hours ago

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

add a comment | 

I'm tasked with structuring a multi-stage project in R, which looks like this:

Intake (continuous) -> collect survey data (using API) -> add respondents to pool -> select respondents based on criteria -> produce graphical report output for selected respondents

I need to:

1. structure the API "intake" script to collect all new responses, on a daily basis


2. Process results, and add results to some kind of database (perhaps SQL but also may be a googlesheet) based upon criteria


3. Make a selection from those respondents, placing some in a secondary "pool" if they don't meet criteria


4. continue process, prioritzing respondents in secondary pool for selection

I have the analysis side down, more or less, and the reporting side, however the transfer between databases, ensuring there is no duplication, and no accounts get lost is definitely my biggest worry. Happy to describe further.

I'm currently looking at setting up a local SQL server on my machine, and using usethis for reporting results. Thanks for any guidance in project management on this topic.

sql google-spreadsheets r project-management rstudio

share|improve this question

asked 12 hours ago

Corey PembletonCorey Pembleton

11

New contributor

Corey Pembleton is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

asked 12 hours ago

Corey PembletonCorey Pembleton

11

New contributor

Corey Pembleton is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

asked 12 hours ago

Corey PembletonCorey Pembleton

11

New contributor

Corey Pembleton is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 12 hours ago

Corey PembletonCorey Pembleton

11

New contributor

Corey Pembleton is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 12 hours ago

Corey PembletonCorey Pembleton

11