Iterating the rows and columns for reading and Writing data in excel || Python openpyxl || Min & Max

[Music] hello guys welcome to my channel Python I declare this is ruffle Jared and today I'm going to show you how to read the data from actual shape using iteration of rows or columns using Python opened by excel so for this I'll be showing you how my data set is available in my excellent shape this is my data sheet the state and capital and I have this six number six rows and two columns so here I will be eating through each rows to get the data or I can I trade through each columns so let me show you or the ways we can I trick based on the requirement first as usual we'll to import the module it is open by Excel now we need to connect to the workbook that is safe path is equal to since it is my lady but six five 2000 by same chart workbook now I know I tried to each rows and columns to get my data for sound in time for seven eight hours yeah maybe you should min/max rotted window equal to if you see my mineral mininum law is to max or equal to 6 don't mean call column is equal to 1 max or equal to 2 and you get the value Sunday okay if you see here my min row is 2 and Max toys 6 same I mean min column is 1 max column is 2 so here's my now we'll be having a fun print statement print so let us run the program attrition Rose is not defined you see ya it is reading Assam this poor Tamilnadu so it is just row wise it is just executing row wise from row to 206 it is executed now we will be adding two columns similarly we can just write the other scores what should do is like it should list all in one set us on tumblr all the state in one set and the next line will be all the capitals see ya sometime another question October CR so make sure and she like these are all in couples and this can be can be modified directly from here if you need to modify anything from here you should change the data set that is if you change it from couple to list so I have an entire tutorial for how to convert the data set from top of the list in my previous videos if you want to do Stannis's kind of for executions you can refer my old video okay next what we are going to say is we will be i trading to each rose we don't need to I trait the columns say a Detroiter two rows only window to max or 6 min column 1 max column 1 or since we're doing this now for sell every Dutch Salgado so if you want to execute if you want to fetch the value only by column-wise of single column then you just go with this formula now if you see it is just going to fetch you for the single column Row one titration for single column okay this is how we can I try to rows or columns to fetch the data fetch the data from excel sheet using opened by excel next we'll be saying how can write n number of data to an exception so I will just remove it so I'll just put time here and I don't need this column I drop now so I'm just show you in one column how to write n number of n number of rows how how do i the data for n number of rows get you take time time so this is the models will be using for doing this activity now we will be defining ask job get a job skewed you what are you to boost an electric that's the dating time of the current current system say x1 equal to take time dot date time time equal to x1 1 St out of time so what's the so this is nothing but we just will be formatting the time d what's in each month this year power percentage and make it and percentage second okay now what we're not going to disturb but we are going to map the path now next what I'm gonna go slide what's the active please Japan yeah time for for our validation part will be using a different time statement seduction where I'm going to write this time that is sick dot cell column equal to one no dot max and discuss Oh plus one and then what's the bed and go to print I'm going to bring time ok so now I'm going to say find out safe still dot F three seconds do schedule well the state minister okay basically what I'm going to do is like I'm going to write I'm going to hydrate the current system date and time again again every five saved I'm going to I trade and I'm going to print that print that current system time in the axle ship so I'll just I tried the Rose while printing it let me show you stick it oh my god what's that okay kidding let's see now okay so here I made a simple mistake it should be for simplicity and I think I mentioned it that it could be I think so let's see yes it should be person density person talented okay okay we have a quite a handful of data let's see whether the actual see whether the did I sell an excel sheet or not yep you can see here this time was already there and it was a start printing beside that next to that particular row and to print n number of rows every five seconds in every five second interval hope you understood my video if you have any doubts you can always write down a comment to me if you liked my video please press like button and for more videos please subscribe my channel thank you for watching

Channel: Rafique javed

Views: 9,351

Keywords: Python, python openpyxl, loop, for loop, iterating through each row and column, write the data in the last row

Id: w49NWbZ3vYc

Length: 11min 8sec (668 seconds)

Published: Thu Jun 04 2020