Have you tried setting a personal access token (PAT) and passing it along as the value of the `auth_token` argument of `install_github()`? 

See `?install_github` way down at the bottom (Package `devtools` version 1.5.0.99). 

Create an access token in:
https://github.com/settings/tokens

Check if your repo has a `master` branch, otherwise use `main`

    devtools::install_github(&quot;user/repo&quot;
                             ,ref=&quot;main&quot;
                             ,auth_token = &quot;tokenstring&quot;
                             )

A more modern solution to this problem is to set your credentials in R using the usethis and credentials packages. 

    #set config
    usethis::use_git_config(user.name = &quot;YourName&quot;, user.email = &quot;your@mail.com&quot;)
    
    #Go to github page to generate token
    usethis::create_github_token() 
    
    #paste your PAT into pop-up that follows...
    credentials::set_github_pat()
    
    #now remotes::install_github() will work
    remotes::install_github(&quot;username/privaterepo&quot;)


More help at https://happygitwithr.com/common-remote-setups.html#common-remote-setups

I would like to purge my SQL database from all entires older than 1 week, and I&#39;d like to do it nightly. So, I&#39;m going to set up a cron job. How do I query mySQL without having to enter my password manually every time?

The query in PHP is as follows:

    mysql_query(&quot;DELETE FROM tbl_message WHERE DATEDIFF( NOW( ) ,  timestamp ) &gt;=7&quot;);

Is there a way to run this as a shell script? If not, is there a way of making cron run a php file?

Run a mySQL query as a cron job?

I would like to get the DATETIME column from an Oracle DB Table with JDBC. Here is my code:

    int columnType = rsmd.getColumnType(i);
    if(columnType == Types.DATE)
    {
        Date aDate = rs.getDate(i);
        valueToInsert = aDate.toString();
    }
    else if(columnType == Types.TIMESTAMP)
    {
        Timestamp aTimeStamp = rs.getTimestamp(i);
    	valueToInsert = aTimeStamp.toString();
    }
    else
    {
    	valueToInsert = rs.getString(i);
    }

I have to identify the column type first. The field I am interested in is recognized as a Types.DATE, but it is really a DATETIME in the DB since it has this format: &quot;07.05.2009 13:49:32&quot;

getDate truncates the time: &quot;07.05.2009&quot;
and getString appends &quot;.0&quot; to it: &quot;07.05.2009 13:49:32.0&quot;

Of course I could just remove the final .0 and work with getString all the time, but it is a dirty workaround.

Any ideas? I was looking for a getDateTime method.




JDBC ResultSet: I need a getDateTime, but there is only getDate and getTimeStamp

I am trying to install a sample package from my github repo:
`https://github.com/jpmarindiaz/samplepkg`

I can install it when the repo is public using any of the following commands through the R interpreter:

- `install_github(&quot;jpmarindiaz/rdali&quot;)`
- `install_github(&quot;rdali&quot;,user=&quot;jpmarindiaz&quot;)`
- `install_github(&quot;jpmarindiaz/rdali&quot;,auth_user=&quot;jpmarindiaz&quot;)`


But when the git repository is private I get an Error:

    Installing github repo samplepkg/master from jpmarindiaz
    Downloading samplepkg.zip from     
    https://github.com/jpmarindiaz/samplepkg/archive/master.zip
    Error: client error: (406) Not Acceptable

I haven&#39;t figured out how the authentication works when the repo is private, any hints?

How to install R package from private repo using devtools install_github?

I am trying to install a sample package from my github repo:
<code>https://github.com/jpmarindiaz/samplepkg</code>
I can install it when the repo is public using any of the following commands through the R interpreter:
<ul>
<li><code>install_github("jpmarindiaz/rdali")</code></li>
<li><code>install_github("rdali",user="jpmarindiaz")</code></li>
<li><code>install_github("jpmarindiaz/rdali",auth_user="jpmarindiaz")</code></li>
</ul>
But when the git repository is private I get an Error:
<pre><code class="hljs language-vbnet">Installing github repo samplepkg/master from jpmarindiaz
Downloading samplepkg.zip from 
https://github.com/jpmarindiaz/samplepkg/archive/master.zip
Error: client error: (406) Not Acceptable
</code></pre>
I haven't figured out how the authentication works when the repo is private, any hints?

I have a data frame 

    a &lt;- runif (10)
    b &lt;- letters [1:10]
    c &lt;- c(rep (&quot;A-B&quot;, 4), rep(&quot;A_C&quot;, 6))
    data1 &lt;- data.frame (a, b, c)
    data1

And I wan to replace `_` in A_C of column c for `-` to have a data frame like data2:

    z &lt;- c(rep (&quot;A-B&quot;, 4), rep(&quot;A-C&quot;, 6))
    data2 &lt;- data.frame (a, b, z)
    data2

Do you know how I can do that?

Replace characters from a column of a data frame R

By using R, is it possible to place 2 ggplot together (i.e., on the same plot)? I wish to show a trend from 2 different data frames and instead of putting them one next to the other, I&#39;d like to integrate them together in one plot and only to change the color of one of them (the black dot).

To be more specific, I have the following 2 visuals:

    ggplot(visual1, aes(ISSUE_DATE,COUNTED)) + geom_point() + geom_smooth(fill=&quot;blue&quot;, colour=&quot;darkblue&quot;, size=1)

and

    ggplot(visual2, aes(ISSUE_DATE,COUNTED)) + geom_point() + geom_smooth(fill=&quot;red&quot;, colour=&quot;red&quot;, size=1)

They look like this (both have black dots and I&#39;ll need to change one of them to something different):


![enter image description here][1]


and

![enter image description here][2]


  [1]: http://i.stack.imgur.com/sDdJm.png
  [2]: http://i.stack.imgur.com/DBNLZ.png

How to combine 2 plots (ggplot) into one plot?

I&#39;m trying to transfer my understanding of plyr into dplyr, but I can&#39;t figure out how to group by multiple columns.

    # make data with weird column names that can&#39;t be hard coded
    data = data.frame(
      asihckhdoydkhxiydfgfTgdsx = sample(LETTERS[1:3], 100, replace=TRUE),
      a30mvxigxkghc5cdsvxvyv0ja = sample(LETTERS[1:3], 100, replace=TRUE),
      value = rnorm(100)
    )
    
    # get the columns we want to average within
    columns = names(data)[-3]
    
    # plyr - works
    ddply(data, columns, summarize, value=mean(value))
    
    # dplyr - raises error
    data %.%
      group_by(columns) %.%
      summarise(Value = mean(value))
    #&gt; Error in eval(expr, envir, enclos) : index out of bounds

What am I missing to translate the plyr example into a dplyr-esque syntax?

**Edit 2017**: Dplyr has been updated, so a simpler solution is available. See the currently selected answer.

Group by multiple columns in dplyr, using string vector input

I have very big .csv file, it&#39;s around a few GB.  
I want to read first few thousand lines of it.
Is there any method to do this efficiently?

How to read first 1000 lines of .csv file into R?

I have a bunch of .RData time-series files and would like to load them directly into Python without first converting the files to some other extension (such as .csv). Any ideas on the best way to accomplish this?


Loading .RData files into Python

I am trying to build a rails project and because the host I am working on doesn&#39;t have access to the Internet for the the git:// protocol (port 9418) I get errors like

    Fetching git://github.com/pivotal/jasmine.git
    fatal: unable to connect to github.com:
    github.com[0: 192.30.252.130]: errno=Connection refused

when running `bundle install`.

The relevant line in the GemFile doesn&#39;t specify git:// as a protocol, it just points to GitHub as the source for the gem

    gem &#39;jasmine&#39;, :github =&gt; &#39;pivotal/jasmine-gem&#39;

What do I have to do to make bundler to use https:// rather than git:// for pulling gems from GitHub?

Edit:

Is there a way other than editing every affected line in the GemFile? I&#39;d prefer to avoid any merging issues down the line if the project&#39;s GemFile is updated.

Force bundle install to use https:// instead of git:// for GitHub-based gems

I have a library `foo/foo-lib` which `requires` a specific commit from GitHub:

    {
        &quot;name&quot;: &quot;foo/foo-lib&quot;,
        &quot;repositories&quot;: [
            {
                &quot;type&quot;: &quot;vcs&quot;,
                &quot;url&quot;: &quot;https://github.com/KnpLabs/Gaufrette.git&quot;
            }
        ],
        &quot;require&quot;: {
            &quot;knplabs/gaufrette&quot;: &quot;dev-master#2633721877cae79ad461f3ca06f3f77fb4fce02e&quot;
        }
    }

and it works fine:

    $ composer update
    Loading composer repositories with package information
    Updating dependencies (including require-dev)                                 
      - Updating knplabs/gaufrette dev-master (2633721 =&gt; 2633721)
        Checking out 2633721877cae79ad461f3ca06f3f77fb4fce02e
    
    Generating autoload files

but when I require that library in other project:

    {
        &quot;name&quot;: &quot;bar/bar-app&quot;,
        &quot;repositories&quot;: [
            {
                &quot;type&quot;: &quot;vcs&quot;,
                &quot;url&quot;: &quot;ssh://git.example.com/foo-lib&quot;
            }
        ],
        &quot;require-dev&quot;: {
            &quot;foo/foo-lib&quot;: &quot;dev-master&quot;
        }
    }

it yields dependency error:

    Your requirements could not be resolved to an installable set of packages.
    
      Problem 1
        - Installation request for foo/foo-lib dev-master -&gt; satisfiable by foo/foo-lib[dev-master].
        - foo/foo-lib dev-master requires knplabs/gaufrette dev-master#2633721877cae79ad461f3ca06f3f77fb4fce02e -&gt; no matching package found.

So my question is: how to correctly `require` the specific commit from GitHub in my library, so that it would be available in dependent packages?

How to correctly require a specific commit in Composer so that it would be available for dependent packages?

I have reported an issue to a project. Now owner changed it state to closed, but how can I change it to open again ?  
I read somewhere that I need rights for push and pull operation. Is that true ?

How to re-open an issue in github?

I want to embed a tweet in a GitHub README file. Markdown should support this, however when I add the code that is copied from the tweet the JavaScript doesn&#39;t get rendered.

Example:

&lt;code&gt;&amp;lt;blockquote&amp;gt;...&amp;lt;/blockquote&amp;gt;&lt;br&gt;
&amp;lt;script async src=&quot;//platform.twitter.com/widgets.js&quot; charset=&quot;utf-8&quot;&amp;gt;&amp;lt;/script&amp;gt;
&lt;/code&gt;

Any ideas?

Embed JavaScript in GitHub README.md

I have an issue with git and my terminal.

Here&#39;s a gallery to show you my issue : http://imgur.com/a/6RrEY

When I push commits from my terminal, git says I push them with another username, that&#39;s a user from my organisation (my company) with no commit at all and it seems it belongs to no one : **(check gallery first pic)**

But this doesn&#39;t happen when I use Github for mac, in the feed I see the commits pushed by myself.

The problem also affects my personal repositories, my terminal says that I don&#39;t have the permission to push commits on those repositories (which is obviously wrong) since it tries to push it with this user : **(check gallery second pic)**

Guess what ? This doesn&#39;t happen with Github for mac too.

I changed my computer to a brand new one few days ago, so I reset&#39;ed all my ssh key of github and left only a new one generated by Github for Mac so I don&#39;t think that there&#39;s some ghost user/ssh key hidden somewhere, this hdd is brand new : **(check gallery third pic)**

My .gitconfig file is all clear, there&#39;s only my credentials : **(check gallery fourth pic)**

I really don&#39;t get it, help, StackOverflow, you&#39;re my only hope.

(My apologies for my poor Gimp skills and the Star Wars reference)

**EDIT :** `ssh-add -l` only shows the good ssh key created by github for mac and I have only one github account

**EDIT2 :** `ssh -T git@github.com` recognize me as the good user.

**EDIT3 :** After a few tests it looks like my terminal does the commits with my username, but pushes them with the other one, Github for mac commits and pushes with the good username.This situation happen with every repo I have/make (even new ones).

**EDIT4 :** In a personal repository `git log --pretty=&quot;%h %an %ae&quot;` shows my good username

**EDIT5 :** No sign of environment variables that would override my credentials in my `env`. Even if I try to set those variables with the good credentials problem persists.

**EDIT6 :** Things work back normally if I force the user in the path of `/.git/config` of a repository but I don&#39;t think that&#39;s the good option : `http://USER@github.com/USER/REPO.git`

**EDIT7 :** We deleted the git user that pushed the commits for me and this brings another error : `remote: Invalid username or password. fatal: Authentication failed for &#39;https://github.com/USER/REPO.git/&#39;`

**FINAL EDIT : I installed git with homebrew, typed** `git config --global push.default simple` **and now it takes my credentials even without forceing the user. That&#39;s strange. Thanks everybody for your help, you&#39;re great guys !**

git pushes with wrong user from terminal

I have the following code with a simple working Vue.js application. But the vue.js devtools is not responding. It was working well a few days ago, now it&#39;s not working anymore what could possibly be going wrong? when I go to [https://chrome.google.com/webstore/detail/vuejs-devtools/nhdogjmejiglipccpnnnanhbledajbpd][1], it says it is already added.


  [1]: https://chrome.google.com/webstore/detail/vuejs-devtools/nhdogjmejiglipccpnnnanhbledajbpd

    &lt;!doctype html&gt;
    &lt;html lang=&quot;en&quot;&gt;
    &lt;head&gt;
      &lt;meta charset=&quot;UTF-8&quot;&gt;
      &lt;meta name=&quot;viewport&quot;
            content=&quot;width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0&quot;&gt;
      &lt;meta http-equiv=&quot;X-UA-Compatible&quot; content=&quot;ie=edge&quot;&gt;
    
      &lt;script src=&quot;https://unpkg.com/vue@2.1.6/dist/vue.js&quot;&gt;&lt;/script&gt;
      
      &lt;title&gt;Document&lt;/title&gt;
    &lt;/head&gt;
    &lt;body&gt;
    &lt;div class=&quot;container&quot;&gt;
      &lt;div id=&quot;application&quot;&gt;
        &lt;input type=&quot;text&quot; v-model=&quot;message&quot;&gt;
        &lt;p&gt;The value of the input is: {{ message }}&lt;/p&gt;
      &lt;/div&gt;
    &lt;/div&gt;
    
    &lt;script&gt;
      let data = {
        message: &#39;Hello World&#39;
      }
      
      new Vue({
        el: &#39;#application&#39;,
        data: data
      })
    &lt;/script&gt;
    &lt;/body&gt;
    &lt;/html&gt;

Content Type	Original Author	Original Content on Stackoverflow
Question	jpmarindiaz	View Question on Stackoverflow
Solution 1 - R	Gabi	View Answer on Stackoverflow
Solution 2 - R	Ferroao	View Answer on Stackoverflow
Solution 3 - R	Brandon Rose	View Answer on Stackoverflow

How to install R package from private repo using devtools install_github?

R Problem Overview

R Solutions

Solution 1 - R

Solution 2 - R

Solution 3 - R

JDBC ResultSet: I need a getDateTime, but there is only getDate and getTimeStamp

Run a mySQL query as a cron job?

Attributions