How to Write Entire Dataframe into MySQL Table in R

Write DataFrame to SPSS .sav File in R

Last Updated : 14 Sep, 2021

In this article, we are going to see how to write Dataframe to SPSS .sav File in R Programming language. The SPSS Statistics File Format is a proprietary binary format, developed and maintained as the native format for the SPSS statistical software application. To write a data frame in SPSS format in R we use the write_sav() function of the haven package in R.

Syntax: write_sav(Data,”Filename.sav”)

Parameters:

Data: Dataframe that is been exported

Filename.sav: Filename where exported dataframe will be stored

Writing dataframe to SPSS .sav file

Here we are going to use the haven package, which is used to read write various data formats.

R

# Create dataframe Demo 
Demo <- data.frame(Batch = c(2017, 2018, 2019, 2020, 2021), 
                  Students = c(2300, 1200, 3500, 1400, 120), 
                  Class = c("DSA Essential", "Placement100", 
                            "C++: Expert",  
                            "Web Development Bootcamp", 
                            "Android Development Bootcamp")) 
  
# load haven package 
library("haven") 
  
# Write file using write_sav() function 
write_sav(Demo, "SPSS.sav")

Output:

After running the code, we see a new file SPSSS.sav in your working directory.

Working directory

We can see data in SPSS.sav file using the following code:

Python3

read.spss("SPSS.sav")

Output

How to Write Entire Dataframe into MySQL Table in R

M

mishrapriyank17

Improve

Article Tags :

Similar Reads

R Read Text File to DataFrame

In today's data-driven world, collecting data from multiple sources and turning it into a structured manner is a critical responsibility for data analysts and scientists. Text files are a prominent source of data, as they frequently include useful information in plain text format. To be used success

How to export dataframe to RDATA file in R?

In this, article we are going to save the information of a data frame in an RDATA file and display the information of the file using R Programming language. To save the information of a data frame in a file and display the information of the file in R language is as follows: Using the save function

Reading the CSV file into Dataframes in R

In this article, we will learn how to import or read a CSV file into a dataframe in R Programming Language. Data set in use: Step 1: Set or change the working directory In order to import or read the given CSV file into our data frame, we first need to check our current working directory, and make s

How to Write Entire Dataframe into MySQL Table in R

In this article, we are going to learn how to write the entire data frame into a MySQL table in R programming language. To perform this task we need some basic requirements which are listed below: Install MySQLInstall R StudioBasic knowledge of SQL queries. Using SQL queries create a database "gfg_d

DataFrame Row Slice in R

In this article, we are going to see how to Slice row in Dataframe using R Programming Language. Row slicing in R is a way to access the data frame rows and further use them for operations or methods. The rows can be accessed in any possible order and stored in other vectors or matrices as well. Row

Reshaping data.frame from wide to long format in R

Reshaping a data frame from wide to long format in R Programming Language is a common operation when dealing with data analysis and visualization. The process involves converting data that is spread across multiple columns (wide format) into a format where each row represents a single observation (l

DataFrame Operations in R

DataFrames are generic data objects of R which are used to store the tabular data. Data frames are considered to be the most popular data objects in R programming because it is more comfortable to analyze the data in the tabular form. Data frames can also be taught as mattresses where each column of

How to Delete DataFrames in R?

In R, a DataFrame is a data structure which can be two-dimensional, that is it can be used to hold data in rows and columns. To create a DataFrame, you can use the data.frame() function. but after you're done with a DataFrame, you may wish to remove it so that memory can be released or your workspac

How to find group-wise summary statistics for R dataframe?

Finding group-wise summary statistics for the dataframe is very useful in understanding our data frame. The summary includes statistical data: mean, median, min, max, and quartiles of the given dataframe. The summary can be computed on a single column or variable, or the entire dataframe. In this ar

How to export a DataFrame to Excel File in R ?

It is a frequent requirement to save our dataframe for portability after working on it on the auxiliary memory of the computer system using R Programming Language. In this article, we will be using writexl package to export our dataframe to excel(.xlsx). The write_xlsx() function of the writexl pack