R/C2/Indexing-and-Slicing-Data-Frames/English - Revision history

Sudhakarst at 12:46, 11 September 2019

2019-09-11T12:46:14Z

Madhurig at 18:09, 19 February 2019

2019-02-19T18:09:09Z

Madhurig at 17:44, 19 February 2019

2019-02-19T17:44:19Z

Madhurig at 17:37, 19 February 2019

2019-02-19T17:37:51Z

Show changes

Sudhakarst at 13:48, 11 February 2019

2019-02-11T13:48:52Z

Sudhakarst at 13:48, 11 February 2019

2019-02-11T13:48:26Z

Sudhakarst at 13:45, 11 February 2019

2019-02-11T13:45:03Z

Show changes

Sudhakarst at 13:43, 11 February 2019

2019-02-11T13:43:06Z

Sudhakarst: Created page with "'''Title of script''': Indexing and Slicing Data Frames '''Author''': Shaik Sameer (IIIT Vadodara) and Sudhakar Kumar (IIT Bombay) '''Keywords''': R, RStudio, data frames,..."

2019-02-11T13:39:22Z

Created page with "'''Title of script''': Indexing and Slicing Data Frames '''Author''': Shaik Sameer (IIIT Vadodara) and Sudhakar Kumar (IIT Bombay) '''Keywords''': R, RStudio, data frames,..."

Show changes

@@ Line 4: / Line 4: @@
 '''Keywords''': R, RStudio, data frames, indexing, slicing, working directory, video tutorial.
 {|border=1
@@ Line 21: / Line 19: @@
 '''Learning Objectives'''
 ||In this tutorial, we will learn how to:
@@ Line 28: / Line 25: @@
 * Create a '''subset''' from a''' data frame'''
 * Retrieve '''data '''using double square brackets
 |-
@@ Line 60: / Line 56: @@
 '''Download Files'''
 ||For this tutorial, we will use the '''data frame CaptaincyData.csv''' and a '''script '''file '''mydataframe.R'''.
 Download these files from the '''Code files''' link of this tutorial.
@@ Line 69: / Line 64: @@
 Highlight '''CaptaincyData.csv '''and''' mydataframe.R '''in the folder '''myProject'''
 ||I have downloaded and moved these files to the folder '''myProject''' on my '''Desktop'''.
 I have also set this folder as my '''Working Directory.'''
@@ Line 81: / Line 75: @@
 Click '''mydataframe.R''' in '''RStudio'''
 Point to''' mydataframe.R''' in '''Rstudio.'''
@@ Line 87: / Line 80: @@
 For this, click on the '''script mydataframe.R'''.
 '''Script mydataframe.R '''opens in '''Rstudio.'''
@@ Line 98: / Line 90: @@
 '''View(captaincy)'''
 ||Here, we have declared a''' variable captaincy''' to store and read '''CaptaincyData.csv'''.
 Also, '''View function''' is being used to see the contents of the file.
@@ Line 105: / Line 96: @@
 ||Highlight''' <-''' symbol in the '''Source''' window
 ||Remember, you may also use '''equal''' to sign in place of '''less than''' symbol followed by '''hyphen'''.
 However, we recommend '''less than''' symbol followed by '''hyphen'''.
 For this, there is a shortcut in '''RStudio'''.
 Suppose we want to assign a value of 2 to a variable named '''testvar'''.
 |-
@@ Line 146: / Line 133: @@
 |-
 ||[RStudio]
 '''captaincy[3,]'''
 ||In the '''Source '''window, type '''captaincy '''
 Type '''capt''' and press '''Enter '''to make the variable '''captaincy '''autocomplete. Now''' '''within square brackets 3 followed by '''comma. '''And press '''Enter'''.
 Press '''Enter '''key''' '''at the end of every command.
@@ Line 207: / Line 191: @@
 |-
 ||[RStudio]
 '''captaincy[c(2,3),]'''
@@ Line 243: / Line 226: @@
 |-
 ||[RStudio]
 '''captaincy[captaincy$played==25,]'''
@@ Line 376: / Line 358: @@
 |-
 ||[RStudio]
 Highlight '''victory '''column of '''captaincy '''in the '''Source '''window
@@ Line 416: / Line 397: @@
 |-
 ||[RStudio]
 Highlight '''select '''
 '''print(subData )'''
 ||The''' select parameter''' is used to select the required columns, '''names''', '''played''', and '''won'''.
 In the '''Source '''window, type '''print''' within '''parentheses subData '''.
@@ Line 447: / Line 425: @@
 |-
 ||[RStudio]
 Highlight the third value of fourth column in '''captaincy '''
 ||Finally, let us learn how to extract a particular entry from some '''column''' of a '''data frame'''.
 We will extract the third value in the fourth '''column''' of the '''captaincy data frame'''.
@@ Line 462: / Line 438: @@
 ||[RStudio]
 '''captaincy[[4]][3]'''
-'''<nowiki>captaincy[[4]][3]</nowiki>'''
 ||In the '''Source '''window, type '''captaincy '''within double square brackets '''4''' within single square brackets '''3'''.

@@ Line 20: / Line 20: @@
 ||Show slide
-Learning Objectives
+'''Learning Objectives'''
@@ Line 33: / Line 33: @@
 ||Show slide
-Pre-requisites
+'''Pre-requisites'''
 ||To understand this tutorial, you should have knowledge about
@@ Line 46: / Line 46: @@
 ||Show slide
-System Specifications
+'''System Specifications'''
 ||This tutorial is recorded on
@@ Line 86: / Line 86: @@
 ||Let us open the '''script mydataframe.R''' in '''RStudio.'''
-For this, click on the '''script mydataframe.R'''
+For this, click on the '''script mydataframe.R'''.
-'''Script mydataframe.R '''opens in''' Rstudio.'''
+'''Script mydataframe.R '''opens in '''Rstudio.'''
 |-
@@ Line 190: / Line 190: @@
 |-
-||
+|| Point to the command.
 ||  So, to extract a '''column''', we shouldn’t use a '''comma''' within the square brackets.
@@ Line 196: / Line 196: @@
 |-
-||
+|| Click on the '''captaincy data frame'''
 ||  In the '''Source '''window, click on the '''captaincy data frame'''.
@@ Line 228: / Line 228: @@
 |-
-||
+||Click on the '''captaincy data frame'''
 ||  In the '''Source '''window, click on the '''captaincy data frame'''.
 |-
-||
+||Cursor on the interface.
 ||Now, we’ll find who has played 25 matches from the '''played''' column of '''captaincy data frame'''.
@@ Line 238: / Line 238: @@
 |-
-||
+||Click on the '''script mydataframe.R'''
 ||Click on the '''script mydataframe.R'''
@@ Line 272: / Line 272: @@
 |-
-||
+||Cursor on the interface.
 ||Now let us learn how to get the values of any particular '''attribute''' for all the players.
@@ Line 328: / Line 328: @@
 |-
-||
+||In the '''Source '''window, click on the '''captaincy data frame'''
 || In the '''Source '''window, click on the '''captaincy data frame'''.
@@ Line 336: / Line 336: @@
 |-
-||
+||Click on the '''script mydataframe.R'''
 ||Click on the '''script mydataframe.R'''
@@ Line 347: / Line 347: @@
 |-
-||Highlight''' c() '''
+||Highlight '''c()'''
 ||Here''' c''' '''function '''is used''' '''to concatenate '''names '''and '''won'''.
@@ Line 363: / Line 363: @@
 |-
-||
+||Point to '''captaincy data frame'''
 ||Now let us extract a '''subset '''from '''captaincy data frame'''.
@@ Line 395: / Line 395: @@
 * number of matches '''won'''
 |-
-||
+||Click on the '''script mydataframe.R'''
 ||Click on the '''script mydataframe.R'''
 |-
-||Resize the '''Source''' window
+||Drag the source window to resize the '''Source''' window
 ||I will resize the '''Source''' window.
@@ Line 411: / Line 411: @@
 |-
-||
+||Press '''Enter'''.
 ||You can press '''Enter''' after a''' comma''' for better visibility.
@@ Line 428: / Line 428: @@
 |-
-||Highlight two lines
+||Highlight two lines.
 Press '''Ctrl + S''' >> Press '''Ctrl+Enter''' keys.
@@ Line 434: / Line 434: @@
 |-
-||
+||Drag the '''Console''' window.
 ||I am resizing the '''Console''' window to see the output properly.
@@ Line 456: / Line 456: @@
 |-
-||
+||Click on the '''script mydataframe.R'''.
-||Click on the '''script mydataframe.R'''
+||Click on the '''script mydataframe.R'''.
 |-
@@ Line 497: / Line 497: @@
 ||We now suggest an assignment.
-* Create a '''subset '''from '''captaincy data frame''' with the captains who have played > 20 matches and lost < 14 matches.
+* Create a '''subset '''from '''captaincy data frame''' with the captains who have played more than(>) 20 matches and lost less than(<) 14 matches.
 |-

@@ Line 34: / Line 34: @@
 Pre-requisites
 ||To understand this tutorial, you should have knowledge about
@@ Line 60: / Line 58: @@
 ||Show slide
+'''Download Files'''
 Download Files
 ||For this tutorial, we will use the '''data frame CaptaincyData.csv''' and a '''script '''file '''mydataframe.R'''.
@@ Line 79: / Line 76: @@
 ||
 ||Let us switch to '''Rstudio'''.
 |-
@@ Line 147: / Line 141: @@
 |-
-||
+||Click on '''script''' '''mydataframe.R'''
 ||Click on the '''script''' '''mydataframe.R'''
@@ Line 163: / Line 157: @@
 Press '''Enter '''key''' '''at the end of every command.
-Remember one of the most important features of '''RStudio '''include intelligent auto-completion of function names, packages, and R objects.
+Remember one of the most important features of '''RStudio''' include intelligent auto-completion of function names, packages, and R objects.
 |-
@@ Line 196: / Line 190: @@
 |-
-| |
+||
-| | So, to extract a '''column''', we shouldn’t use a '''comma''' within the square brackets.
+||  So, to extract a '''column''', we shouldn’t use a '''comma''' within the square brackets.
 When we extract '''data''' using row number or column number, it is known as numeric indexing.
 |-
-| |
+||
-| | In the '''Source '''window, click on the '''captaincy data frame'''.
+||  In the '''Source '''window, click on the '''captaincy data frame'''.
 |-
@@ Line 216: / Line 210: @@
 '''captaincy[c(2,3),]'''
 ||To retrieve more than one '''row''', we use a numeric '''index vector'''. Click on the '''script mydataframe.R'''
@@ Line 237: / Line 229: @@
 |-
 ||
-| | In the '''Source '''window, click on the '''captaincy data frame'''.
+||  In the '''Source '''window, click on the '''captaincy data frame'''.
 |-
@@ Line 277: / Line 269: @@
 |-
 ||click on the '''captaincy data frame''' in '''Source''' window.
-| | In the '''Source '''window, click on the '''captaincy data frame'''.
+||  In the '''Source '''window, click on the '''captaincy data frame'''.
 |-
@@ Line 299: / Line 291: @@
 |-
 ||Highlight 1 in square brackets
 ||Please note that I have not used a '''comma''' inside the square brackets.
@@ Line 340: / Line 329: @@
 |-
 ||
-| | In the '''Source '''window, click on the '''captaincy data frame'''.
+|| In the '''Source '''window, click on the '''captaincy data frame'''.
 |-
@@ Line 354: / Line 343: @@
 '''captaincy[c("names", "won")]'''
 ||In the '''Source '''window, type the following command and press '''Enter'''.
@@ Line 385: / Line 372: @@
 |-
 ||click on the '''captaincy data frame''' in '''Source''' window.
-| | In the '''Source '''window, click on the '''captaincy data frame'''.
+|| In the '''Source '''window, click on the '''captaincy data frame'''.
 |-
@@ Line 401: / Line 388: @@
 Highlight '''names''', '''played '''and '''won '''columns of '''captaincy'''
 ||For this '''subset''', we shall only show the
@@ Line 409: / Line 394: @@
 * number of matches '''played'''
 * number of matches '''won'''
 |-
 ||
@@ Line 417: / Line 399: @@
 |-
-||
+||Resize the '''Source''' window
 ||I will resize the '''Source''' window.
@@ Line 461: / Line 443: @@
 |-
 ||Click on the '''captaincy data frame''' in '''Source''' window.
-| | In the '''Source '''window, click on the '''captaincy data frame'''.
+|| In the '''Source '''window, click on the '''captaincy data frame'''.
 |-
@@ Line 509: / Line 491: @@
 * Create a '''subset''' from a '''data frame '''
 * Retrieve data using double square brackets
 |-
-||Slide 8
+||Show slide
 Assignment
@@ Line 519: / Line 498: @@
 * Create a '''subset '''from '''captaincy data frame''' with the captains who have played > 20 matches and lost < 14 matches.
 |-

@@ Line 4: / Line 4: @@
 '''Keywords''': R, RStudio, data frames, indexing, slicing, working directory, video tutorial.
 {| style="border-spacing:0;width:18.785cm;"
@@ Line 446: / Line 445: @@
 Thank You
 | style="background-color:#ffffff;border-top:none;border-bottom:1.25pt solid #000001;border-left:1.25pt solid #000001;border-right:1.25pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.203cm;padding-right:0.191cm;" | <span style="background-color:#ffffff;">The script for this tutorial was contributed by Shaik Sameer (FOSSEE Fellow 2018).</span>
 <span style="background-color:#ffffff;">This is Sudhakar Kumar from IIT Bombay signing off. Thanks for watching.</span>
 |-
 |}

@@ Line 119: / Line 119: @@
 |-
 | style="background-color:#ffffff;border-top:none;border-bottom:1.25pt solid #000001;border-left:1.25pt solid #000001;border-right:none;padding-top:0cm;padding-bottom:0cm;padding-left:0.203cm;padding-right:0.191cm;" | [RStudio]
 '''captaincy[3,]'''
@@ Line 316: / Line 315: @@
 Highlight '''names''', '''played '''and '''won '''columns of '''captaincy'''
-| style="background-color:#ffffff;border-top:none;border-bottom:1.25pt solid #000001;border-left:1.25pt solid #000001;border-right:1.25pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.203cm;padding-right:0.191cm;" | <span style="background-color:#ffffff;">For this </span><span style="background-color:#ffffff;">'''subset'''</span><span style="background-color:#ffffff;">, we shall only show the </span>* <div style="margin-left:1.947cm;margin-right:0cm;"><span style="background-color:#ffffff;">names</span></div>
+| style="background-color:#ffffff;border-top:none;border-bottom:1.25pt solid #000001;border-left:1.25pt solid #000001;border-right:1.25pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.203cm;padding-right:0.191cm;" | <span style="background-color:#ffffff;">For this </span><span style="background-color:#ffffff;">'''subset'''</span><span style="background-color:#ffffff;">, we shall only show the </span>
 * <div style="margin-left:1.947cm;margin-right:0cm;"><span style="background-color:#ffffff;">number of matches </span><span style="background-color:#ffffff;">'''played'''</span></div>
 * <div style="margin-left:1.947cm;margin-right:0cm;"><span style="background-color:#ffffff;">number of matches </span><span style="background-color:#ffffff;">'''won'''</span></div>

@@ Line 4: / Line 4: @@
 '''Keywords''': R, RStudio, data frames, indexing, slicing, working directory, video tutorial.
@@ Line 21: / Line 20: @@
 Learning Objectives
 | style="background-color:#ffffff;border-top:none;border-bottom:1.25pt solid #000001;border-left:1.25pt solid #000001;border-right:1.25pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.203cm;padding-right:0.191cm;" | In this tutorial, we will learn how to:
 * <div style="margin-left:1.947cm;margin-right:0cm;">Extract '''rows''' or '''columns''' from a '''data '''frame</div>
 | style="background-color:#ffffff;border-top:none;border-bottom:1.25pt solid #000001;border-left:1.25pt solid #000001;border-right:1.25pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.203cm;padding-right:0.191cm;" | In this tutorial, we will learn how to:* <div style="margin-left:1.947cm;margin-right:0cm;">Extract '''rows''' or '''columns''' from a '''data '''frame</div>
 * <div style="margin-left:1.947cm;margin-right:0cm;">Create a '''subset''' from a''' data frame'''</div>
 * <div style="margin-left:1.947cm;margin-right:0cm;">Retrieve '''data '''using double square brackets</div>
 |-
@@ Line 33: / Line 30: @@
 Pre-requisites
 | style="background-color:#ffffff;border-top:none;border-bottom:1.25pt solid #000001;border-left:1.25pt solid #000001;border-right:1.25pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.203cm;padding-right:0.191cm;" | To understand this tutorial, you should have knowledge about
 * <div style="margin-left:1.947cm;margin-right:0cm;">'''Data frames''' in''' R''' </div>
 | style="background-color:#ffffff;border-top:none;border-bottom:1.25pt solid #000001;border-left:1.25pt solid #000001;border-right:1.25pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.203cm;padding-right:0.191cm;" | To understand this tutorial, you should have knowledge about * <div style="margin-left:1.947cm;margin-right:0cm;">'''Data frames''' in''' R''' </div>
 * <div style="margin-left:1.947cm;margin-right:0cm;">'''R''' '''script '''in '''RStudio '''and</div>
 * <div style="margin-left:1.947cm;margin-right:0cm;">How to set '''Working directory''' in''' RStudio'''</div>
 If not, please locate the relevant tutorials on '''R''' on this website.
@@ Line 46: / Line 40: @@
 System Specifications
-| style="background-color:#ffffff;border-top:none;border-bottom:1.25pt solid #000001;border-left:1.25pt solid #000001;border-right:1.25pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.203cm;padding-right:0.191cm;" | This tutorial is recorded on* <div style="margin-left:1.947cm;margin-right:0cm;">'''Ubuntu Linux '''OS version''' 16.04'''</div>
+| style="background-color:#ffffff;border-top:none;border-bottom:1.25pt solid #000001;border-left:1.25pt solid #000001;border-right:1.25pt solid #000001;padding-top:0cm;padding-bottom:0cm;padding-left:0.203cm;padding-right:0.191cm;" | This tutorial is recorded on
 * <div style="margin-left:1.947cm;margin-right:0cm;">'''R '''version''' 3.2.3'''</div>
 * <div style="margin-left:1.947cm;margin-right:0cm;">'''RStudio''' version''' 1.1.456'''</div>