Let us use the below given sampleExcelFile.xlsx<\/strong> Excel File here:<\/p>\n <\/p>\n Below are the ways to convert an Excel Column into a list of vectors:<\/p>\n Here we will just use the $-operator with the column name and the name of the data retrieved from the excel file in this method.<\/p>\n Syntax:<\/strong><\/p>\n Approach:<\/strong><\/p>\n Below is the implementation:<\/strong><\/p>\n Output:<\/strong><\/p>\n In this method, the user only needs to enter the column name inside the brackets columns with the data. To turn that Excel column into a vector. This will just convert the column to the vector that the user passed with the brackets along with its data.<\/p>\n Syntax:<\/strong><\/p>\n Approach:<\/strong><\/p>\n Below is the implementation:<\/strong><\/p>\n Output:<\/strong><\/p>\n In this method, the user must invoke the pull() function from the R language’s dplyr package, passing the column name to be converted into vector form and the name of the datafile read variable.<\/p>\n Installation:<\/strong><\/p>\n Output:<\/strong><\/p>\n pull Function:<\/strong><\/p>\n The pull function selects a column from a data frame and converts it to a vector.<\/p>\n Syntax:<\/strong><\/p>\n Parameters<\/strong><\/p>\n Return Value:<\/strong> A vector of the specified column is returned by the pull() function .<\/p>\n Approach:<\/strong><\/p>\n Below is the implementation:<\/strong><\/p>\n Output:<\/strong><\/p>\n Read More:<\/p>\n WIPRO Pivot Point Calculator<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"![\"sample-excel-file-sheet1-image\"](\"https:\/\/sheetstips.com\/wp-content\/uploads\/2022\/06\/sample-excel-file-sheet1-image.jpg\")
<\/p>\nConverting an Excel Column into a List of vectors in R<\/h2>\n
\n
Method #1: Using $-Operator (with the column name)<\/h3>\n
\n
dataframe$column<\/pre>\n
\n
# Import readxl package using the library() function\r\nlibrary(readxl)\r\n\r\n# Pass the excel file path as an argument to the read_excel() function and \r\n# to read the given excel file and store it in a variable\r\ngvn_exceldata<- read_excel(\"C:\/Users\/cirus\/Downloads\/excelFile.xlsx\")\r\n# Get the column data as vector using $ operator by passing the column name and apply it on the above excel file\r\nrslr_vector<-gvn_exceldata$age \r\n# Display the above vector \r\nrslr_vector<\/pre>\n
[1] 21 22 19 20 18 23 32 34 36 39 42 66<\/pre>\n
Method #2: Using the Method of Subsetting Column<\/h3>\n
dataframe[row_name,column_name]<\/pre>\n
\n
# Import readxl package using the library() function\r\nlibrary(readxl)\r\n\r\n# Pass the excel file path as an argument to the read_excel() function and \r\n# to read the given excel file and store it in a variable\r\ngvn_exceldata<- read_excel(\"C:\/Users\/cirus\/Downloads\/excelFile.xlsx\")\r\n# Get the column data as vector by passing the column name in [] operator and apply it to the above excel file \r\nrslr_vector<- gvn_exceldata[ , \"Website name\"] \r\n# Display the above vector \r\nrslr_vector<\/pre>\n
# A tibble: 12 \u00d7 1\r\n`Website name` \r\n<chr> \r\n1 Sheets Tips \r\n2 Python-Programs\r\n3 BTechGeeks \r\n4 PythonArray \r\n5 Sheets Tips \r\n6 Python-Programs\r\n7 Sheets Tips \r\n8 Python-Programs\r\n9 BTechGeeks \r\n10 PythonArray \r\n11 Sheets Tips \r\n12 Python-Programs<\/pre>\n
Method #3: Using the pull function from dplyr package<\/h3>\n
install.packages(\"dplyr\")<\/pre>\n
Installing package into \u2018C:\/Users\/cirus\/AppData\/Local\/R\/win-library\/4.2\u2019\r\n(as \u2018lib\u2019 is unspecified)\r\n--- Please select a CRAN mirror for use in this session ---\r\ntrying URL 'https:\/\/cloud.r-project.org\/bin\/windows\/contrib\/4.2\/dplyr_1.0.9.zip'\r\nContent type 'application\/zip' length 1290875 bytes (1.2 MB)\r\ndownloaded 1.2 MB\r\n\r\npackage \u2018dplyr\u2019 successfully unpacked and MD5 sums checked\r\n\r\nThe downloaded binary packages are in\r\nC:\\Users\\cirus\\AppData\\Local\\Temp\\RtmpE3dtfs\\downloaded_packages<\/pre>\n
pull(.data, j)<\/pre>\n
\n
\n
# Import readxl package using the library() function\r\nlibrary(readxl)\r\n\r\n# Pass the excel file path as an argument to the read_excel() function and \r\n# to read the given excel file and store it in a variable\r\ngvn_exceldata<- read_excel(\"C:\/Users\/cirus\/Downloads\/excelFile.xlsx\")\r\n# Import the dplyr package using the library() function\r\nlibrary(\"dplyr\") \r\n# Pass the given excel file and column name to the pull function\r\nrslr_vector \uff1c- pull(gvn_exceldata,age) \r\n# Display the above vector \r\nrslr_vector<\/pre>\n
[1] 21 22 19 20 18 23 32 34 36 39 42 66<\/pre>\n