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! 🤘

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

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

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

[@manu77564]

thanks a ton for this. waiting for next session.

[@WafaStudies]

Thank you Fayaz 😇

[@nadirkhmd]

Please talk about scheduling pipelines through databricks

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

[@sravankumar1767]

Nice explanation bro 👍 👌 👏

[@WafaStudies]

Thank you 😊

[@adianalytics4566]

Clear explaination 👍

[@pigrebanto]

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

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

[@amanpathak7507]

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

[@mainuddinali9561]

plz upload dataset and script slide fo better practice

[@anilsthanam409]

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

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

❣❣

[@vutv5742]

Completed

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