Collaborate on Lab Bill Format for R&D with Ease Using airSlate SignNow

Lab bill format for R&D

foreign in this lesson we will look at how to create data frames in r a data frame is a table or a two-dimensional array-like structure in which each column contains values of one variable and each draw contains one set of values from each column the data stored in a data frame can be of numeric factor or character type let's create a data frame for the student data where we have the student IDs their names and their marks so to create a data frame we use the function data dot frame here we give the name to the data frame as student.data and inside the data dot frame function we have three arguments first is the student ID that is from 1 to 5 then we have the student names so here are the five names Williams James Olivia Steve and David and last is their marks student marks for each student let's create it and let's run this so our data frame is created to display the data frame simply write its name and run it so here you can see the tabulated data we just created where we have the student IDs their names and their marks and the columns headings we just assigned in the data frame to look at the structure of the data frame we use the function Str let's run it this gives the complete information along with each column data type to look at the summary of the data frame just use the summary function here when I run it this gives the complete summary of the data we have and for the numeric values it shows the statistics data and for the strings its length and class length of the function is used to look at the length of the data frames this basically gives us the column count in most of the cases so here it returns 3 as we have three columns as well then we have the dimension function which gives the information about the number of raws and columns so we have five rows and three columns we can also check the rows and columns individually as well okay then we have the attribute function this shows the overall information of the data frame its names class and draw names all right so here in line 38 I will declare a new data frame which contains the user data so we have serial numbers from 1 to 5 then we have names their ages and their heights let's print the data frame and run line 38 this time we will look at how to write the data frame to our CSV file for this we use the function write.csv the input arguments are the data frame then the name of the file that you want to save with and then giving raw names as false because we don't want raw names to be in the CSV files if you want them just change it to True let's run it here you can see in the file list the CSV is created let me open it for you so here is our saved data we can also import the data as a data frame here I have the famous Titanic data set you can also find the file for it in the resource section as well so to import a file we use the function read.csv and give the file name I have directly given the file name because it is in my current working directory now let's save it in the Titanic data set variable first then I will convert it into the data frame let's print it so here you can see the data frame for Titanic data set is printed this is how you create data frames in art export them to a CSV file and import a CSV file as a data frame in this lesson we will look at how to access the data frames in r so here we have the two data frames one is for the student marks for the English course and the other is for the student marks for the mathematics course let's create the two data frames so for that I will run the code okay so the two data frames has been created now next let's access the student dot data maths data frame so here in line number 19 I will access the First Column of the data frame let's run it so you see it Returns the student IDs from the student.data maths data frame you can also use the negative integer indexing so the phenomena is the same as here in line 22 I have written -2 this means that we will access all The Columns of the data frames except for the column 2. let's run it so here you see we get the first and the third column of the data frame Columns of the data frames can also be accessed using the dollar sign so to access the respective columns we write the data frame name like I have written here student dot data maths and after the dollar sign I am to access the column with name student underscore marks underscore maths so this will access the marks column for this data frame let's run it and here it returns to Mark's values in the form of the vector now we can also access The Columns of the data frame and save itself in a data frame format like here in line number 28 we are storing the column names and marks from the student Dot data English data frame and storing it in variable marks underscore English let's store it and then let's print the result so here we get the table in which we have the names and their marks for the English course now we will look at how to combine different data frames in a variable so we have the student IDs and student names in both the data frames we declared right so what I'm to do is store the marks of the student for both the courses English and maths in a single variable so here we are accessing the complete data frame student.data English and only the marks column which is at index 3 of the data maths data frame let's run it and print the result so here you can see we get the combined data frames with student names and their marks for both the courses the same can also be done using the dollar sign to access the same index column that contains the student marks in the student.data maths data frame now let's execute line 35 and 36 and here you will find the same results there it is so we get the same results as before you can also export the file in a CSV format so to do so we use the right dot CSV function here I am saving the result data from data frame as marks.csv and I am not saving the raw names just the column names so let's run this and the file is created in the current working directory let's refresh it and here is the file let's open it so this is the output so this is how we access the data frames in r in this lesson we will look at how to modify the values and update the values of the data frames in r here I will first declare the data frame with the name student dot data English it is the same as the previous ones let me create it and print the data frame so the First Transformation we will do to our data frame is adding a new column to the created data frame I will add a new column which will represent the grades for the marks of the students so for this we use the C bind function short for Columbine this binds the newly defined column with the previous Columns of the data frame the column name is assigned as grades now let me run line 17 now let's print the updated data frame so here you can see that we have the updated data frame with the grades column now in it you can also add a new data entry for the whole data frame so over here in the line 24 I have defined a new student data this his name ID marks and grades now let me create this data so let's run it now let me print the new student data for you here you can see we have his ID as 6 name as George his marks and his grades as well now I will add this data to the previously created data frame so to update this entry we use the rbind function that is short for raw bind function here we have entered the name for data frame which is update1.std data English which was the one we added grades in this one and then I give the second argument which is the student data let's run it and let's print the new updated data frame so here you can see we have the updated data frame with the sixth entry in here dropping a raw in the data frame can be done this way so here I have created a new variable with the name update 3 dot STD data English from our update2.std data English we will fetch all the raws except for raw 2. let's run it and check the newly updated frame so you see that raw 2 which contained the data for James is now deleted in the same way we can also drop a particular column like here I will drop the fourth column from our data frame which is the grades column and then I will save it in the update 4 dot STD data English so here you can see that the grades column is now dropped now let's see how you can get the column of a data frame in the vector format so over here I'm accessing the First Column of the data frame let's run it so here we get student IDs from one to six and if we access the same index number using the double square brackets R Returns the values of that column in the form of vectors so I hope you have got an understanding of how you can transform and modify data frames in r in this lesson we will perform some operation on data frames in r so here I have declared the user data data frame same as before it contains the names of the user their ages and their heights let's print this data frame you can see all the columns with different names their ages and their heights so as of a first operation I will perform the sum operation on the user.h column let's run it and here we get the answer as 203 which is the sum of all the person ages in our data set similarly I will calculate the mean let me run it so this is 40.6 then I will calculate the standard deviation so it is 13.86 okay to search a particular value in the data we use the percent in person function so here I am looking for 180 in the data frame column for a height now let's run it so it returns false also I will search for 165 and this time it returns true because it is present in the height column so this is it on how we perform basic operations on data frames in our [Music]