5. Read json file into DataFrame using Pyspark | Azure Databricks

In this video, I discussed about reading json file data into dataframe using pyspark.
Link for PySpark Playlist:
• 1. What is PySpark?
Link for PySpark Real Time Scenarios Playlist:
• 1. Remove double quote...
Link for Azure Synapse Analytics Playlist:
• 1. Introduction to Azu...
Link to Azure Synapse Real Time scenarios Playlist:
• Azure Synapse Analytic...
Link for Azure Data bricks Play list:
• 1. Introduction to Az...
Link for Azure Functions Play list:
• 1. Introduction to Azu...
Link for Azure Basics Play list:
• 1. What is Azure and C...
Link for Azure Data factory Play list:
• 1. Introduction to Azu...
Link for Azure Data Factory Real time Scenarios
• 1. Handle Error Rows i...
Link for Azure Logic Apps playlist
• 1. Introduction to Azu...
#PySpark #Spark #Databricks #notebook #PySparkcode #dataframe #WafaStudies #maheer #azure #azuredatabricks

[@mangoshala8174]

Dude, you made PySpark so simple that even a 5th grader could be a programmer! 🤘

[@user-oh6nb4jl9m]

Thank you Maheer, I was learning on udemy and other UA-cam channel but trust me you are the best and doing really wonderful job, really like your playlist on real time scenarios, if possible can you please do one on streaming as well. Thank you very much for such wonderful job.

[@shuaibsaqib5085]

Hi Maheer Bhai,
Kindly make a playlist on spark optimization and performance tuning which would help in real time scenarios as most of your videos are very helpful in real time projects.

[@SanjayKumar-rw2gj]

Thanks for this great playlist. Learning pyspark seems very easy because of this.

[@vivekmadas8183]

You are doing great work and your videos are awesome.
I am learning Databricks from your playlist.
Most of my time is getting wasted in typing and with syntax issues.
It would be very helpful if you can provide scripts/artifacts that you have covered in the videos itself. It saves a lot of our time and helps us learn the subject quickly.

[@VivekKBangaru]

Awesome, But 1 addition, while modifying the Json schema, we should give the same key(name, add,phone)as like json data to the Struct Field data, otherwise we will get NULL response for the column .
{
'name': 'Kodi',
'add': 'Samarayapatti',
'phone': 11
}
schema = StructType().add(field='Name', data_type=StringType()).add(field='Address', data_type=StringType()).add(field='Phone', data_type=IntegerType())

[@waseembari2125]

Hi I tried your method its not working,even by changing the StructField which matches JSON fields

[@NeumsFor9]

You should do a follow up to this.... parsing out the metadata of an ADF pipeline and write into an integrated . metadata repo.

[@pigrebanto]

tks. does not work with dbfs: in the path. When files are local it works for me with file:/

[@manu77564]

thanks a ton for this. waiting for next session.

[@WafaStudies]

Thank you Fayaz 😇

[@starmscloud]

Hello Maheer . Your Videos are good. Increase the frequency of these videos like 2-3 per week .

[@WafaStudies]

Sure Manoj. Thank you ☺️

[@mohitawasthi7866]

Thanks Maheer. Great video, can you explain how to read nested JSON in pyspark

[@nadirkhmd]

Please talk about scheduling pipelines through databricks

[@nareshkumar1919]

Hi Maheer, Thank you so much for making best videos and can you please make an video in future how to read API json/xml data it would be great you made. Once again thank you sou much for making a videos.

[@sravankumar1767]

Nice explanation bro 👍 👌 👏

[@WafaStudies]

Thank you 😊

[@vutv5742]

Completed

[@adianalytics4566]

Clear explaination 👍

[@sandeepbarge4699]

Can you please do one video on how do you read nested JSON file in PySpark?

[@adityashrivastava860]

I have one suggestion please also provide these files or data so that we don't have to create these (csv, json) files while coding along with.

[@mainuddinali9561]

plz upload dataset and script slide fo better practice

[@amanpathak7507]

Hi Maheer, please provide the data files and notebooks and presentation so we don't need to prepare for it

[@satishmajji481]

How to read data from a complex nested json?

[@WafaStudies]

U need to apply multiple functions and flatten them slolwy nide by node. I will try to do this video as part PySpark real time scenarios playlist soon. Thank you 😊

[@satishmajji481]

@@WafaStudies Thanks for the reply. Please make a video on this ASAP. You're doing a wonderful job.

[@WafaStudies]

@@satishmajji481 sure Satish. Thank you ☺️

[@MBA_ANALYST]

❣❣

[@ashwinkumar5223]

Share dataset and notepad

[@WafaStudies]

I will try to plan my personal website in the future very soon. From there u guys can download files and slides of videos

[@Aneelkumarrr]

what is the difference between read.json and fromat."json"?.