Posts

Showing posts with the label Python Text Files

Featured Post

Python Program: JSON to CSV Conversion

Image
JavaScript object notion is also called JSON file, it's data you can write to a CSV file. Here's a sample python logic for your ready reference.  You can write a simple python program by importing the JSON, and CSV packages. This is your first step. It is helpful to use all the JSON methods in your python logic. That means the required package is JSON. So far, so good. In the next step, I'll show you how to write a Python program. You'll also find each term explained. What is JSON File JSON is key value pair file. The popular use of JSON file is to transmit data between heterogeneous applications. Python supports JSON file. What is CSV File The CSV is comma separated file. It is popularly used to send and receive data. How to Write JSON file data to a CSV file Here the JSON data that has written to CSV file. It's simple method and you can use for CSV file conversion use. import csv, json json_string = '[{"value1": 1, "value2": 2,"value3

How to Read CSV Files in Python

Image
Here is a way to read  CSV files  in Python pandas. The packages you need to import are numpy and pandas. On the flip side, f or Text files, you don't need to import these special libraries since python by default support it. Python pandas read_csv >>> import numpy as np >>> import pandas as pd To see how pandas handle this kind of data, we'll create a small CSV file in the working directory as ch05_01.csv. white, red, blue, green, animal 1,5,2,3,cat  2,7,8,5,dog  3,3,6,7,horse  2,2,8,3,duck  4,4,2,1,mouse Since this file is comma-delimited , you can use the read_csv() function to read its content and convert it to a dataframe object. >>> csvframe = pd.read_csv('ch05_01.csv') >>> csvframe white red blue green animal 0 1 5 2 3 cat 1 2 7 8 5 dog 2 3 3 6 7 horse 3 2 2 8 3 duck 4 4 4 2 1 mouse Python reading text files Since python supp