teleren/devto huggingface dataset:
R Function to Split CSVs
Tags: eto, hmis, r, sql
Published: 2016-12-31 10:00:00

---
title: R Function to Split CSVs
tags: eto, hmis, r, sql
published_at: 20161231T10:00Z
canonical_url: https://ladvien.com/r-function-to-split-csvs
main_image: https://ladvien.com/images/R_SQL.png
series: HMIS SQL-R Script Snippets
published: true
---

This is an R function written to split a dataset into particular sized sets, then write them as a CSV.  Often, our office is need a quick way to split files for uploading purposes, since our HMIS software doesn't handle large uploads well.  

For example:

```r
splitDataAndWriteFiles(df, 500, "My_Data")  
```

Will produce X number of files named "My_data_X.csv"

```r
options(java.parameters = "-Xmx14336m")  ## memory set to 14 GB
library("XLConnect")

# Function to split files.
splitDataAndWriteFiles <- function(df, chunkSize, nameOfFiles) {
  success <- FALSE
  count <- 0
  while (!success) {
    # If you want 20 samples, put any range of 20 values within the range of number of rows
    s <- paste(((count*chunkSize)+1), "_", ((count+1)*chunkSize))
    print(s)
    chunk <- subset(df[((count*chunkSize)+1):((count+1)*chunkSize),])
    #chunk <- sample(df[5:20,])
    ## this would contain first 20 rows
    fileName <- paste(nameOfFiles, "_", as.character(count), ".csv")
    # Write out all the Active HUD Assessments.
    write.csv(chunk, file = fileName, na = "", row.names = FALSE, fileEncoding = "utf8")
    count <- count + 1
    success <- (count * chunkSize) > nrow(df)
  }
  return(success)
}

fileToSplit <- read.csv("UPLOAD -- Sal Men-- TCES Move -- TSA Bed Data Template.csv")

splitDataAndWriteFiles(fileToSplit, 5000, "Sal_Men_NBN")
```
Hi, I'm kiran kumar
Tags: introductions
Published: 2016-12-31 09:46:17

---
title: Hi, I'm kiran kumar
published: true
description: I am new to development world but very interested in programming.
cover_image: 
tags: introductions
---

I have just started coding

You can find me on Twitter as [@ChirravuriNani](https://twitter.com/ChirravuriNani)

I live in [India].

I work for [Gurujada IT Solutions]

I mostly program in these languages: [Ruby].

I am currently learning more about [Ruby On Rails].

Nice to meet you.
I recently deleted a bunch of old code, and I feel good about it!
Tags: 100daysofcode
Published: 2016-12-30 20:32:03

---
title: I recently deleted a bunch of old code, and I feel good about it!
published: true
description: 
cover_image: 
tags: 100daysofcode
---

We had a bunch of old code lying around the dev.to from features we never fully implemented. For a while they were just lying around because we *might* have finished them. I finally got around to just deleting it all, and man do I feel good about it!

I am reminded me of this talk.

## Katrina Owen on Therapeutic Refactoring

{% youtube J4dlF0kcThQ %}
100 days of writing about code
Tags: 100daysofcode
Published: 2016-12-30 18:20:37

---
title: 100 days of writing about code
published: true
description: Starting January 3rd, I am going to write about code (almost) every day. No excuses!
cover_image: https://media.giphy.com/media/l0HlKWbgtjw3DIgLK/source.gif
tags: 100daysofcode
---

'Tis the season to take on personal challenges. Reading about the [#100DaysOfCode](https://medium.freecodecamp.com/start-2017-with-the-100daysofcode-improved-and-updated-18ce604b237b#.ulzr6kc9r) challenge has me feeling the spirit. That challenge a simple personal goal to sit down and code about 100 days in a row. It is a wonderful undertaking for new coders, who need to soak up experience and may be feeling other things in life tugging at their motivation. 

For slightly more experienced programmers, perhaps coding *a lot* already for work, this may not be what we need. Personally, the eat, sleep, code, repeat mentality is not going to do a lot of good for my psychological well-being. However, in the spirit of the 100 days of code challenge, I am going to take on the **100 days of writing about code challenge**.

![2017](https://media.giphy.com/media/3o6UB9IxAjNdyIgUKY/giphy.gif)

A lot of folks [mentioned](https://dev.to/ben/what-are-your-programming-goals-for-2017) blogging and becoming more involved in the community as a goal of theirs for 2017, and I have similar ambitions. I would like to achieve a rhythm where I am capable of publishing my thoughts on code with more regularity. I often succumb to the paralysis of wondering whether an idea is worth sharing.

So I am just going to do it. (Almost) every day starting January 3rd, I am going to write *something* about code, even if it's short and useless. I have lots I am doing, and lots to contribute. I feel great sharing my thoughts and learn so much from the feedback every time I do. I really enjoy writing about web performance, and I think I have a lot to offer in that regard. I will also write about new languages and tools I try out, as well as wholly new endeavors, like game development, which I plan to dabble in on the side this year.

I am going to publish it all to my [dev.to/ben](https://dev.to/ben) feed and make it about the exercise of doing. I will share it all on my personal Twitter, [@bendhalpern](https://twitter.com/bendhalpern). A few decent pieces might be quality enough to show up on the [dev.to](https://dev.to) home page and even fewer will make it to [@ThePracticalDev](https://twitter.com/thepracticaldev).

I will adopt the [#100daysofcode](https://dev.to/t/100daysofcode) tag on this site as well as on Twitter, but my personal challenge is about the writing part. If you are reading this and feeling the same way as I am, I encourage you to take part! You are more than welcome to publish to [dev.to](https://dev.to) along with me. That will make it easiest for me to keep up with your efforts and cheer you on, but you are more than welcome to publish to your own blog (or both!) and I will try to keep up if you let me know.

See you in 2017! ✊
Hi, I'm Said
Tags: introductions
Published: 2016-12-30 11:42:42

---
title: Hi, I'm Said
published: true
description: My introduction post
cover_image: 
tags: introductions
---

I have been coding for 2 years.

You can find me on Twitter as [@SaId_ArAb](https://twitter.com/SaId_ArAb)

I live in algeirs.

I work for Emploipartner.com

I mostly program in these languages: php , java , js , python .
 
I do scripting  and scrapping when i get bored .

I am currently learning more about AI and machine learning .

Nice to meet you.
Action Potential - A mini-app for real-time distributed decisions (and a 2-day learning experiment in Firebase)
Tags: showdev, firebase
Published: 2016-12-30 03:54:19

---
title: Action Potential - A mini-app for real-time distributed decisions (and a 2-day learning experiment in Firebase)
published: true
description: 
cover_image: 
tags: showdev, firebase
---

Wanted to learn Firebase and so built a mini-app aimed at real-time distributed decisions.

http://actionpotential.jeremyrgordon.com

Feedback welcome.
Hi, I'm Meheret Girma
Tags: introductions
Published: 2016-12-29 21:49:19

---
title: Hi, I'm Meheret Girma
published: true
description: My introduction post
cover_image: 
tags: introductions
---

I have been coding for [1] years.

You can find me on Twitter as [@lilymercy](https://twitter.com/lilymercy)

I live in [Maryland].

I work for [company]

I mostly program in these languages: [Javascript].

I am currently learning more about [Javascript].

Nice to meet you.
Hi, I'm rafi
Tags: introductions
Published: 2016-12-29 20:16:05

---
title: Hi, I'm rafi
published: true
description: a brief summary of myself
cover_image: 
tags: introductions
---

I have been coding for [1,5] years.

You can find me on GitHub as [radicalrafi](https://github.com/radicalrafi)

I live in [redacted].

I work for [small AI startup ]

I mostly program in these languages: [C++ |Python|C|amateur clojurist and haskellian].

I am currently learning more about [machine learning and artificial intelligence ].

Nice to meet y'all.
Cloudready or how to get a Chrome OS in a non-Chromebook laptop
Tags: offtropic
Published: 2017-12-05 17:03:26

---
title: "Cloudready or how to get a Chrome OS in a non-Chromebook laptop"
published: true
tags: offtropic
canonical_url: https://leonardofaria.net/2016/12/29/cloudready-or-how-to-get-a-chrome-os-in-a-non-chromebook-laptop/
---

Few months ago I saw in The Verge a [post](http://www.theverge.com/2016/3/7/11173836/neverware-cloudready-how-to-convert-pc-into-chromebook-free) about [CloudReady](https://www.neverware.com/). CloudReady is a remake of Chromium OS ready to go in old PCs or Macs. The company behind the product sells its solutions/support to organizations interested in keeping using their hardware. It’s really interesting.

<iframe width="500" height="281" src="https://www.youtube.com/embed/NAakr95sLOI?feature=oembed" frameborder="0" allowfullscreen></iframe>  
  
I am writing this post because my wife has an old Samsung laptop and I finally found a time to give a chance to CloudReady. Her laptop was initially running Windows 7 and it was updated to Windows 10. The idea was using CloudReady in another partition and using Grub to handle the boot process like any Linux distribution.

Unfortunately, this process was more difficult that I thought. In fact CloudReady supports [dual-boot installation](https://guide.neverware.com/install-cloudready/#select-dual-boot-or-standalone) but there are few details to pay attention:

- If you are using an old computer, you probably need to convert Windows BIOS (MBR) to UEFI. I am not going to describe this once Microsoft Technet has a [detailed article](http://social.technet.microsoft.com/wiki/contents/articles/14286.converting-windows-bios-installation-to-uefi.aspx) about it.
- I initially partitioned the HDD in 1 partition for Windows and I left unlocated space for CloudReady. Windows 10 was installed in its partition without problems.
- The last step was booting CloudReady from a Flash Drive and proceding the installation according to its [documentation](https://guide.neverware.com/critical-requirements/) The dual-boot worked like a charm.

My first impression is that CloudReady is faster and smooth than Windows. In addition, there are no infinite updates, malwares and all the crappy things that we are used to seeing in Windows. It is definitely a good way to bring to life again an old computer. One bad thing that happened it that CloudReady stopped working and I needed to redo all the installation process.
Hi, I'm Gonzalo
Tags: introductions
Published: 2016-12-29 18:31:24

---
title: Hi, I'm Gonzalo
published: true
description: My introduction post
cover_image: 
tags: introductions
---

I have been coding for over 10 years.

You can find me on GitHub as [gonzalodelgado](https://github.com/gonzalodelgado), although I mainly use GitLab (also there as [gonzalodelgado](https://gitlab.com/u/gonzalodelgado)).

I live in San Miguel de TucumÃ¡n.

I work for [Five Q](http://fiveq.com).

I mostly program in Python and Javascript.

I am currently learning more about gamedev, Haxe and HaxeFlixel.

Nice to meet you!
Hi, I'm Rob
Tags: introductions
Published: 2016-12-29 17:42:23

---
title: Hi, I'm Rob
published: true
description: My introduction post
cover_image: 
tags: introductions
---

I have been coding for 10 or so years.

You can find me on Twitter as [@RobertTilling](https://twitter.com/RobertTilling)

I live in Southampton.

I work for myself as a contractor.

I mostly program in these languages: C# and JavaScript.

I am currently learning more about vue.js.

Nice to meet you.
Hi, I'm Omar!
Tags: introductions
Published: 2016-12-29 17:34:16

---
title: Hi, I'm Omar!
published: true
description: My introduction post
cover_image: 
tags: introductions
---

I've been programming ever since I was 12, started off by making games on ROBLOX and have recently moved on to work on more ambitious projects. You can check out some of my most recent experimental projects at https://omarsinan.com

Nice to meet you! :-)
Hi, I'm Erika
Tags: introductions
Published: 2016-12-29 05:12:08

---
title: Hi, I'm Erika
published: true
description: My introduction post
cover_image: https://source.unsplash.com/YCQFgqOzLmU
tags: introductions
---

I have been coding for 5 years. I live in Victoria & Vancouver and work for SKIO Music.

You can find me on Twitter as [@OneEaredMusic](https://twitter.com/OneEaredMusic), on GitHub as [eburdon](https://github.com/eburdon), or at my website at [erikaburdon.ca](erikaburdon.ca)

I mostly program professionally in Java, Python, JavaScript. My personal projects are currently in Go and Scala. I'm trying to learn more about MVPs, Code Smells, and Functional Programming at the moment.

Nice to meet you. Please speak loudly.
Hi, I'm Lars
Tags: introductions
Published: 2016-12-28 22:17:30

---
title: Hi, I'm Lars
published: true
description: My introduction post
cover_image: 
tags: introductions
---

I have been coding, running servers and breaking them for >15 years.
The first 5 languages I learned: C, Java, PHP, bash, Perl
You can find me on Twitter as [@bob5ec](https://twitter.com/bob5ec)

I am currently working on integrating Security into Continues Delivery aka Secure SDLC, DevSecOps, or SecDevOps.

If you care about Security Architecture or Thread Modeling, please drop me a line and share your thoughts.

In case you are writing programs that read or write data, please read about [LangSec](http://langsec.org) and start to use grammars, parsers and unparsers to avoid 50% of security bugs.
Hello Startup - Microreview
Published: 2023-04-29 22:27:11

---
title: Hello Startup - Microreview
published: true
date: 2016-12-28 18:24:31 UTC
tags: 
canonical_url: https://mikestaszel.com/2016/12/28/hello-startup-microreview.html
---

I just finished reading “Hello, Startup” by Yevgeniy Brikman, a book written for programmers about starting a startup. All the basics are covered, including hiring, teamwork, startup culture, and development methodology while scaling a startup. It’s a nice quick read (I skimmed through the chapters about development, programming, databases, and other technical chapters, but I found the other content to be a great place to start learning about what it takes to build a startup.

Check it out here (also available on Safari Books): [http://www.hello-startup.net](http://www.hello-startup.net)
About Matthew
Tags: introduction
Published: 2016-12-28 17:58:43

---
title: About Matthew
published: true
description: About me
cover_image: http://anotherdevblog.net/assets/images/family.jpg
tags: introduction
---

My name is Matthew Watkins. I'm a software engineer, a husband, a father, a blogger, and a Mormon.

## What I do
I currently work at a Morrisville, NC ecommerce company called [ChannelAdvisor](http://www.channeladvisor.com). We are a SAAS business, working to make selling online easier for businesses. Seriously great place, seriously good people.

## Why I do it
When I was young, I always wanted to be an inventor. I always dreamed I would be some Wayne Szalinski, creating some new and innovative products that would make peoples' lives easier or less tedious. Software development allows me to design, build, and invent like that every single day. It's awesome.

## What I do while code is compiling
- Achieve Inbox Zero
- Check out other dev blogs
- Wish my code compiled faster

<hr />

This post first appeared on [Another Dev Blog](http://anotherdevblog.net/about/)
Hi, I'm Kyle Welch
Tags: introductions
Published: 2016-12-28 14:14:13

---
title: Hi, I'm Kyle Welch
published: true
description: My introduction post
cover_image: 
tags: introductions
---

I have been coding for 10+ years.

You can find me on Twitter as [@kylewelch](https://twitter.com/kylewelch)

I live in Nashville,TN and grew up in a suburb of Chicago.

I work for National Federation of Independent Business, as the Sr. Developer leading the front-end team. 

I mostly program in these languages: Javascript using React, but have done things with a handful or more other languages.

I am currently learning more about node, babel-plugins, and webpack.

Nice to meet you.
Introducing: My Toolbox!
Tags: toolbox
Published: 2018-01-03 02:48:10

---
title: "Introducing: My Toolbox!"
published: true
tags: toolbox
canonical_url: https://SeanKilleen.com/2016/12/introducing-my-toolbox/
---

Figured I’d write a quick post here to announce the new [Toolbox section on SeanKilleen.com](http://SeanKilleen.com/toolbox)!

There are a ton of great tools that I use every day, and this is a way of keeping a running list of them for myself and others.

I hope you enjoy!

[Introducing: My Toolbox!](https://SeanKilleen.com/2016/12/introducing-my-toolbox/) was originally published by Sean Killeen at [SeanKilleen.com](https://SeanKilleen.com) on December 28, 2016.
Quick Tip: A Shortcut to Temporarily Disable ReSharper
Tags: quicktips, dotnet, resharper
Published: 2018-01-03 02:47:51

---
title: "Quick Tip: A Shortcut to Temporarily Disable ReSharper"
published: true
tags: QuickTips,dotnet,resharper
canonical_url: https://SeanKilleen.com/2016/12/quick-tip-disable-resharper-shortcut/
---

## Problem

I love ReSharper, but it comes with some performance implications, and sometimes I need it to go away for a few minutes, particularly when I’m working with a large codebase.

## Solution

You can create a keyboard shortcut to toggle ReSharper.

- Open Visual Studio
- Head to `Tools` –\> `Options` –\> `Keyboard`
- Set shortcut for `ReSharper_ToggleSuspended` (you can search for it in the menu) 
  - I used `CTRL` + `ALT` + `R`

Now, you should be able to toggle ReSharper whenever you need to.

Happy coding!

[Quick Tip: A Shortcut to Temporarily Disable ReSharper](https://SeanKilleen.com/2016/12/quick-tip-disable-resharper-shortcut/) was originally published by Sean Killeen at [SeanKilleen.com](https://SeanKilleen.com) on December 27, 2016.
Avoiding Primitive Obsession in Configuration -- My Approach
Tags: dotnet, configuration
Published: 2018-01-03 02:47:20

---
title: "Avoiding Primitive Obsession in Configuration -- My Approach"
published: true
tags: dotnet,configuration
canonical_url: https://SeanKilleen.com/2016/12/avoiding-primative-obession-configuration-as-contract/
---

I woke up this morning and saw [a great blog post by Arialdo Martini](http://arialdomartini.github.io/primitive-obsession.html) that inspired me to blog a little bit (thanks, Arialdo!)

In the post, he describes the problems of using primitive variables in your classes, and the pitfalls of using a service locator pattern to resolve those issues. It’s a good read; I recommend checking it out. The conclusion he came to (and I’m greatly oversimplifying here) is that configuration settings work better as value objects, and shows some tricks for how to achieve this in a more painless way.

I definitely agree that a value object is better than a primitive when it makes sense. However, there are times when a collection of primitives does make the most sense.

So, I thought I’d share some current thoughts on how I prefer to inject configuration into my classes.

[Read the rest of this post on Excella.com](https://www.excella.com/insights/avoiding-primitive-obsession-in-configuration-my-approach)

[On Excella: Avoiding Primitive Obsession in Configuration -- My Approach](https://SeanKilleen.com/2016/12/avoiding-primative-obession-configuration-as-contract/) was originally published by Sean Killeen at [SeanKilleen.com](https://SeanKilleen.com) on December 27, 2016.
Explore Bucharest -- Dorobanti
Tags: bucharest, explore, dorobanti, post
Published: 2019-01-20 15:01:05

---
title: Explore Bucharest -- Dorobanti
published: true
tags: bucharest,explore,dorobanti,post
canonical_url: https://horia141.com/explore-bucharest-dorobanti.html
series: "Explore Bucharest"
---

![Dorobanti 1](https://horia141.com/assets/dorobanti-1.jpg)

![Dorobanti 2](https://horia141.com/assets/dorobanti-2.jpg)

![Dorobanti 3](https://horia141.com/assets/dorobanti-3.jpg)

![Dorobanti 4](https://horia141.com/assets/dorobanti-4.jpg)

![Dorobanti 5](https://horia141.com/assets/dorobanti-5.jpg)

![Dorobanti 6](https://horia141.com/assets/dorobanti-6.jpg)

![Dorobanti 7](https://horia141.com/assets/dorobanti-7.jpg)

![Dorobanti 8](https://horia141.com/assets/dorobanti-8.jpg)

![Dorobanti 9](https://horia141.com/assets/dorobanti-9.jpg)

![Dorobanti 10](https://horia141.com/assets/dorobanti-10.jpg)

![Dorobanti 11](https://horia141.com/assets/dorobanti-11.jpg)

![Dorobanti 12](https://horia141.com/assets/dorobanti-12.jpg)
Hi, I'm Ahmed Kabir Maruf.
Tags: introductions
Published: 2016-12-27 14:04:15

---
title: Hi, I'm Ahmed Kabir Maruf.
published: true
description: My introduction post
cover_image: 
tags: introductions
---

I have been coding for [0] years.

You can find me on Twitter as [@imakm247](https://twitter.com/imakm247)

I live in [Sylhet, Bangladesh].

I work for [nobody]

I mostly program in these languages: [English].

I am currently learning more about [PHP].

Nice to meet you.
SQL is Insecure
Tags: security, sql
Published: 2016-12-25 04:47:34

---
title: "SQL is Insecure"
published: true
description: "It's been decades and we still can't write SQL securely. It's time to abandon it."
cover_image: https://cdn.pixabay.com/photo/2015/09/27/02/26/broken-window-960188_1280.jpg
tags: security, sql
---

SQL is insecure, tell everyone. If you use SQL, your website will get hacked. Tell everyone.

I saw the news that the US Elections Agency [was hacked by a SQL injection attack][1] and I kind of lost it. It's been well over two decades since [prepared statements][1.5] were introduced. We've [educated and advised][2] developers about how to avoid SQL injection, yet it still happens. If education failed, all we can do is shame developers into never using SQL.

I actually really like SQL, I've even made [a SQL dialect][3]. SQL's relational algebra is expressive, probably more so than any other NoSQL database I know of. But developers have proven far too often that it's simply too difficult to know when to use prepared statements or just concatenate strings — it's time we just abandon SQL altogether. It isn't worth it. It's time we called for all government's to ban use of SQL databases in government contracts and in healthcare. There must be utter clarity.

Part of the problem is the curse of the junior developer. They're experienced enough to realize that their employers will reward rapid development, but inexperienced enough to not understand the tremendous cost associated with sloppy code.

As a senior develper you might note that a relational database provides the flexibility you need to be successful. You know how to use prepared statements to prevent SQL injection. They are a little more work than simply concatenating user input with executable SQL code, but not much more. The decision seems obvious: use SQL.

But 2 years from now, after you quit this job, a very junior developer picks up your code with some very tight deadlines and a ton of management pressure. Does he know about prepared statements? Maybe, maybe not. Either way, it is a lot easier and faster to slop the code together and get shit done, so that's what he does.

It's time we accepted fate and let SQL die. Software runs our world now. When our software fails, people's lives actually get messed up. Companies will always want software to be made for cheap, but it's our ethical responsibility as senior developers to prevent future mistakes from being made under pressure.

Security is paramount. Your customers are worth it. Abandon SQL.


 [1]: http://www.reuters.com/article/us-election-hack-commission-idUSKBN1442VC
 [1.5]: https://en.wikipedia.org/wiki/Prepared_statement
 [2]: https://ics-cert.us-cert.gov/sites/default/files/recommended_practices/DHS_Common_Cybersecurity_Vulnerabilities_ICS_2010.pdf
 [3]: http://docs.aws.amazon.com/iot/latest/developerguide/iot-sql-reference.html