The following sample code (by Python and C#) shows how to read query data in the DataFrame. Once you have a DataFrame object, you can query the data using the SQL-like syntax regardless of the origin of data.

The following sample code (by Python and C#) shows how to read JSON file with complex objects.

CSV handles the flat data structure. But with JSON, you can read complex data structure into the DataFrame.

The following sample code (by Python and C#) shows how to read JSON file with array data.

With JSON, it is easy to specify the schema. Therefore, you can directly parse the array data into the DataFrame.

The following sample code (by Python and C#) shows how to read JSON file with schema. With JSON, it is always a good idea to provide the schema for your data.

The following sample code (by Python and C#) shows how to read CSV file with a column of array.

CSV does not support complex objects such as an array. To make it work, you need to pass a JSON array in CSV and parse it. You will learn this trick here.

JSON array format is like this.

["Ford", "Toyota", "BMW", "Fiat"]

The following sample code (by Python and C#) shows how to read CSV file with schema. You will see how you can specify the schema explicitly.

The following sample code (by Python and C#) shows how to read CSV file without schema.

The following sample code (by Python and C#) shows how to count the word in a text file.