<commit_before><section class="rAccess">
  <b>R</b>
  <p>Make sure that you have R and RStudio installed on your machine.</p>
  <p>Run the following commands using the latest AACT 2.0 connection information</p>

  <pre>
    <code>> install.packages("RPostgreSQL")</code>
    <code class="output">trying URL 'https://cran.rstudio.com/bin/macosx/mavericks/contrib/3.3/RPostgreSQL_0.4-1.tgz'</code>
    <code class="output">Content type 'application/x-gzip' length 306320 bytes (299 KB)</code>
    <code class="output">==================================================</code>
    <code class="output">downloaded 299 KB</code>
    <code>> library(RPostgreSQL)</code>
    <code class="output">Loading required package: DBI</code>
    <code>> drv <- dbDriver('PostgreSQL')</code>
    <code>> con <- dbConnect(drv, dbname="<%= ENV["RDS_DB_READONLY_DBNAME"] %>",host="<%= ENV["RDS_DB_HOSTNAME"] %>",port=5432,user="<%= ENV["RDS_DB_READONLY_USERNAME"] %>",password="<%= ENV["RDS_DB_READONLY_PASSWORD"] %>")</code>
    <code>> aact2_sample <- dbGetQuery(con,"select distinct study_type from studies")</code>
    <code>> write.csv(aact2_sample, file='aact2_sample.csv')</code>
  </pre>
</section><commit_msg>r links added for install instructions<commit_after><section class="rAccess">
  <b>R</b>
  <p>If R and RStudio are not already installed, install from these two links:</p>

  <p><a href="https://cran.r-project.org/">Install R from your closest mirror</a></p>
  <p><a href="https://www.rstudio.com/products/rstudio/">Install RStudio</a></p>

  <p>Once R and RStudio are installed, run the following commands using the latest AACT 2.0 connection information</p>
  <pre>
    <code>> install.packages("RPostgreSQL")</code>
    <code class="output">trying URL 'https://cran.rstudio.com/bin/macosx/mavericks/contrib/3.3/RPostgreSQL_0.4-1.tgz'</code>
    <code class="output">Content type 'application/x-gzip' length 306320 bytes (299 KB)</code>
    <code class="output">==================================================</code>
    <code class="output">downloaded 299 KB</code>
    <code>> library(RPostgreSQL)</code>
    <code class="output">Loading required package: DBI</code>
    <code>> drv <- dbDriver('PostgreSQL')</code>
    <code>> con <- dbConnect(drv, dbname="<%= ENV["RDS_DB_READONLY_DBNAME"] %>",host="<%= ENV["RDS_DB_HOSTNAME"] %>",port=5432,user="<%= ENV["RDS_DB_READONLY_USERNAME"] %>",password="<%= ENV["<PASSWORD>ONLY_PASSWORD"] %>")</code>
    <code>> aact2_sample <- dbGetQuery(con,"select distinct study_type from studies")</code>
    <code>> write.csv(aact2_sample, file='aact2_sample.csv')</code>
  </pre>
</section>
{'fraction_non_alphanumeric': 0.2215887495248955, 'fraction_numerical': 0.01976434815659445, 'mean_word_length': 5.54726368159204, 'pattern_counts': {'":': 0, '<': 90, '<?xml version=': 0, '>': 96, 'https://': 4, 'lorem ipsum': 0, 'www.': 1, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 2, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '214575', 'n_tokens_mistral': 956, 'n_tokens_neox': 898, 'n_words': 185}