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

[@mangoshala8174]

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

[@SanjayKumar-rw2gj]

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

[@MangeshDeshpande-m2n]

Thank you Maheer, I was learning on udemy and other KZbin 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.

[@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

[@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.

[@anilsthanam409]

How can we read two jason files , one with multiliner = false and other with multiliner=true. Kindly make a video. THank you.

[@manu77564]

thanks a ton for this. waiting for next session.

[@WafaStudies]

Thank you Fayaz 😇

[@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:/

[@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.

[@sravankumar1767]

Nice explanation bro 👍 👌 👏

[@WafaStudies]

Thank you 😊

[@starmscloud]

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

[@WafaStudies]

Sure Manoj. Thank you ☺️

[@nadirkhmd]

Please talk about scheduling pipelines through databricks

[@mohitawasthi7866]

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

[@adianalytics4566]

Clear explaination 👍

[@sandeepbarge4699]

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

[@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.

[@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 ☺️

[@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

[@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.

[@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

[@vutv5742]

Completed

[@MBA_ANALYST]

❣❣

[@Aneelkumarrr]

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