/Python/Convert pandas dataframe to spark dataframe

Convert pandas dataframe to spark dataframe

import pandas as pd
from pyspark.sql import SparkSession

filename = <'path to file'>
spark = SparkSession.build.appName('pandasToSpark').getOrCreate()
# Assuming file is csv
pandas_df = pd.read_csv(filename)
spark_df = spark.CreateDataFrame(pandas_df)

Dataframe pandas to spark

from pyspark.sql import SparkSession
#Create PySpark SparkSession
spark = SparkSession.builder \
    .master("local[1]") \
    .appName("SparkByExamples.com") \
    .getOrCreate()
#Create PySpark DataFrame from Pandas
sparkDF=spark.createDataFrame(pandasDF) 
sparkDF.printSchema()
sparkDF.show()

#Outputs below schema & DataFrame

root
 |-- Name: string (nullable = true)
 |-- Age: long (nullable = true)

+------+---+
|  Name|Age|
+------+---+
| Scott| 50|
|  Jeff| 45|
|Thomas| 54|
|   Ann| 34|
+------+---+

Source: sparkbyexamples.com

Similar codes

0 vote166 views1 answer
Change command aliad
Python
2 votes172 views1 answer
How to change pygame window icon
Python
18 votes339 views5 answers
Flask minimal app
Python Flask
0 vote187 views1 answer
How to populate an image to template in django from views
Python
15 votes163 views5 answers
Tkinter tutorial
Python
0 vote173 views1 answer
Python open dicom
Python
0 vote176 views1 answer
Get context data django
Python
15 votes349 views6 answers
How to install flask
Python Flask
12 votes187 views2 answers
Python how to return max num index
Python
0 vote168 views1 answer
Pandas to tensor torch
Python