Python implementation in C#

Question

Hi, How to get result in datatable in C# after run python script?

Tuhin Paul · Answer

Hi Amit, thanks for posting the question. This is a great learning experience to be able to answer this question. I hope the code below might answer your question. To get the result of a Python script in a C# DataTable , see below: 1. Create a new Python script that returns the result as a CSV file or a JSON file . For example, you can use the csv module in Python to write the result to a CSV file: import csv # your Python code that generates the result result = [['Name', 'Age'], ['John', 30], ['Jane', 25]] # write the result to a CSV file with open('result.csv', 'w', newline='') as csvfile: writer = csv.writer(csvfile) for row in result: writer.writerow(row) 2. Call the Python script from C# using the Process class. Pass any necessary arguments to the Python script using the Arguments property of the ProcessStartInfo object. In this example, we assume that the Python script is named script.py and is located in the same directory as the C# code, this code calls a Python script and stores the result in a DataTable: using System; using System.Diagnostics; using System.Data; using System.IO; class Program { static void Main(string[] args) { // create a new Process instance Process process = new Process(); // configure the ProcessStartInfo object ProcessStartInfo startInfo = new ProcessStartInfo(); startInfo.FileName = "python"; // the name of the Python interpreter startInfo.Arguments = "script.py"; // the name of your Python script startInfo.UseShellExecute = false; startInfo.RedirectStandardOutput = true; startInfo.CreateNoWindow = true; process.StartInfo = startInfo; // start the process and wait for it to finish process.Start(); process.WaitForExit(); // read the output of the Python script and store it in a DataTable DataTable dataTable = new DataTable(); dataTable.Columns.Add("Name"); dataTable.Columns.Add("Age"); using (StreamReader reader = process.StandardOutput) { while (!reader.EndOfStream) { string line = reader.ReadLine(); string[] values = line.Split(','); DataRow row = dataTable.NewRow(); row["Name"] = values[0]; row["Age"] = values[1]; dataTable.Rows.Add(row); } } // print the DataTable foreach (DataRow row in dataTable.Rows) { Console.WriteLine("{0} - {1}", row["Name"], row["Age"]); } } } In this code, we assume that the Python script returns the result as a CSV file with two columns: " Name " and " Age ". The C# code reads the output of the Python script and stores it in a DataTable with the same columns. Finally, the code prints the DataTable to the console. You can modify the code to write the DataTable to a file, display it in a UI, or perform any other operation as needed. Let me know if it helps you in a way. Good Luck.

Uttam Kumar · Answer

Amit, 2nd example shown by Tuhin shows how you can handle datatable returned by python script in c#.

Amit Kumar · Answer

Thanks Tuhin, But our python script return tabulate (like datatable) not in file with , seperated. But read line read data from a file right. Any idea for read data from datatable

Uttam Kumar · Answer

Tuhin, very well explained with the example.