How to remove extra rows and columns with NA values when importing from csv file using R -

-

i have started learning r. i'm trying input data .csv file , r keeps adding rows , columns na values. know why might happening? advice on removing these na appreciated. have used following code:

>no_col <- max(count.fields("6%aa_comp.csv", sep=",")) >mydata <- read.csv(file="6%aa_comp.csv", fill=true, header=true, col.names = 1:no_col-1) >mydata  x0     x1     x2     x3 x4 1  206428 152160 122080 111940 na 2  183620 148300 118820 107260 na 3  169100 164480 151420 146200 na 4  179000 135920 107340  93540 na 5  213820 146640 113040 109140 na 6  150920 141400 133600 132000 na 7  185645 154000 124510 128900 na 8  176102 139100 141000 110300 na 9  159045 154350 121050 153500 na 10 198610 161000 119000 105600 na 11 183100 138900 141500 129550 na 12 211050 142550 136700 113500 na 13 167000 150100 120000 102540 na 14     na     na     na     na na 15     na     na     na     na na 16     na     na     na     na na

well, data cleansing half job or more. can read file , clean indexing rows , columns interested in, in case be:

mydata <- read.csv(file="6%aa_comp.csv", fill=true, header=true) mydata <- mydata[1:13, 1:5]

Comments

Post a Comment

Popular posts from this blog

javascript - Chart.js (Radar Chart) different scaleLineColor for each scaleLine -

-
Image
i try , create radar chart using chart.js has various colours each scaleline, or coloured between scalelines. wondering if possible? from: to: i have working graph, though there doesn't seem method change individual scale lines. kind regards leigh you can extend radar chart type this, so chart.types.radar.extend({ name: "radaralt", initialize: function (data) { chart.types.radar.prototype.initialize.apply(this, arguments); var originalscaledraw = this.scale.draw; var ctx = this.chart.ctx; this.scale.draw = function () { var linewidth = this.linewidth; // bypasses line drawing in originalscaledraw this.linewidth = linewidth; originalscaledraw.apply(this, arguments); ctx.linewidth = this.linewidth; var scale = this; // draw chart.helpers.each(scale.ylabels, function (label, index) { // color of ...
Read more

apache - Error with PHP mail(): Multiple or malformed newlines found in additional_header -

-
suddenly have started receiving above error without changes having been made script. host 1and1 (i know...) the script still works fine on different server, , suspicion there must have been server config change has lead this, although hosts plead ignorance. there's no information on above error @ in google can find - have ideas? server running apache if helps. had similar problem. came out of blue. no php code changed. what changed: php upgraded 5.5.25-1 5.5.26. a security risk in php mail() function has been fixed , newlines in additional_headers allowed no more. because newlines mean: starts email message (and surely don't want inject newlines through headers followed evil message). what have worked fine, e.g. having newlines after headers or passing whole message additional_headers , function no more. solution : sanitize headers. no multiple newlines in additional_headers argument. these count "multiple or malformed newlines":...
Read more

java - Android – MapFragment overlay button shadow, just like MyLocation button -

-
Image
i'm struggling add shadow custom overlay button on google map. goal make custom button google's mylocation button. here's how app looks now: layout.xml <relativelayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" xmlns:map="http://schemas.android.com/apk/res-auto" android:layout_height="match_parent" android:layout_width="match_parent" style="@style/apptheme"> <fragment android:layout_width="match_parent" android:layout_height="match_parent" android:id="@+id/map" tools:context=".mapsactivity" android:name="com.google.android.gms.maps.supportmapfragment" android:layout_alignparentend="true" android:layout_alignparentstart="true" android:layout_alignparentbottom="true" ...
Read more