Tag: dataframe

how to export data from SQL in R

I’m a beginner in R. I have connection via ODBC to SQL DB: dbconnection <- odbcDriverConnect("Driver=ODBC Driver 11 for SQL Server;Server=OurServer; Database=OurDatabase;Uid=; Pwd=") initdata <...

Dataframe transformation (preparation to sql export)

dataframe r sql transformation

How to make such transformation as in the below image ?

Filtering a Pyspark DataFrame with SQL-like IN clause

apache-spark dataframe pyspark python sql

I want to filter a Pyspark DataFrame with a SQL-like IN clause, as in sc = SparkContext() sqlc = SQLContext(sc) df = sqlc.sql(‘SELECT * from my_df WHERE field1 IN a’) where a is the tuple (1, 2, 3). …