Python/C2/loading-data-from-files/English-timed

Time	Narration
00:01	Hello Friends and Welcome to this tutorial on "loading data from files".
00:06	At the end of this tutorial, you will be able to, Read data from files, containing a single column of data Read multiple columns of data, separated by spaces or other delimiters.
00:19	Let us switch to the terminal and start IPython, using ipython hypen pylab
00:33	Now, Let us begin with reading the file primes.txt, which contains a list of prime numbers listed in a column, using the loadtxt command.
00:45	Please make sure that you provide the correct path of the file, 'primes.txt'.
00:50	The file, in our case, is presented in slash home slash fossee slash primes.txt.
00:59	Otherwise we can use the cat command to locate the file and read the contents of it.
01:05	So type cat slash home slash fossee slash primes.txt
01:15	Now let us read this list into the variable primes.
01:20	So type primes = loadtxt within bracket in single quotes slash home slash fossee slash primes.txt
01:41	primes is now a sequence of prime numbers, that was listed in the file,``primes.txt``.
01:49	We now type primes,print primes to see the sequence printed so type print space primes.
02:00	We observe that all the numbers end with a period.
02:04	This is so, because these numbers are actually read as floats
02:10	Now, let us use the loadtxt command to read a file pendulum.txt that contains two columns of data.
02:19	This file contains the length of the pendulum in the first column and the corresponding time period in the second.
02:26	Note that here loadtxt needs both the columns to have equal number of rows.
02:31	We can use the cat command to view the contents of this file.
02:36	So type cat slash home slash fossee slash pendulum.txt
02:50	Let us, now, read the data into the variable pend.
02:55	Again, it is assumed that the file is in slash home slash fossee
03:02	So type pend = loadtxt within bracket in single quote slash home slash fossee slash pendulum.txt
03:21	Let us now print the variable pend and see what it contains.
03:26	So type print pend
03:31	Notice that pend is not a simple sequence like primes .
03:35	It has two sequences, containing both the columns of the data file.
03:40	Let us use an additional argument of the load txt command, to read it into two separate, simple sequences.
03:50	So type L, T space = space load txt within bracket single quote slash home slash fossee slash pendulum.txt comma unpack=True
04:23	Let us now, print the variables L and T, to see what they contain.
04:29	So type print space L print space T
04:39	Notice, that L and T now contain the first and second columns of data from the data file, pendulum.txt, and they are both simple sequences.
04:50	unpack=True has given us the two columns into two separate sequences instead of one complex sequence.
05:00	Till now, we have learnt the basic use of the load txt command.
05:05	Let us try an example.
05:07	Pause the video here, try out the following exercise and resume the video.
05:12	Read the file pendulum underscore semicolon.txt which contains the same data as pendulum.txt, but the columns are separated by semi-colons instead of spaces.
05:27	Use the IPython help to see how to do this.
05:34	Switch back to the terminal L comma T = loadtxt within bracket in single quote slash home slash fossee slash pendulum underscore semicolon.txt comma unpack=True comma delimiter=semi-colon within single quote
06:54	Okay then type print L
06:40	print T
06:45	This brings us to the end of this tutorial.
06:48	In this tutorial, we have learnt to,
06:51	1. To Read data from files, containing a single column of data using the loadtxt command.
06:58	2. To Read multiple columns of data, separated by spaces or other delimiters.
07:04	Here are some self assessment questions for you to solve 1. loadtxt can read data from a file with one column only. True or False?
07:18	2. Given a file data.txt with three columns of data separated by spaces, read it into 3 separate simple sequences.
07:29	3. Given a file data.txt with three columns of data separated by ":", read it into 3 separate simple sequences.
07:45	And now the answers,1. False.
07:50	loadtxt command can read data from files having both single columns as well as multiple columns.
07:58	2. A file with three columns of data separated by spaces to be read into 3 separate sequences, we use the loadtxt command as, x = loadtxt within bracket in double quotes data.txt comma unpack=True
08:19	3. If a file with three columns of data separated by delimiters,we read it into three separate sequences by using an additional argument of delimiter in the loadtxt command x = loadtxt within bracket in double quotes data.txt comma unpack=True comma delimiter=in double quotes semicolon)
08:51	Hope you have enjoyed this tutorial and found it useful.
08:55	Thank you!

Contributors and Content Editors

Gaurav, Minal, PoojaMoolya, Sneha