There’s more than one way to do this, but I’m assuming that you’re a beginner and as such you’re learning the basics.
When planning a program, thing about what data you have, what you plan on doing with said data and what data types you have in order to accomplish the task.
This site covers the basics and much more, but there are others:
This is a start for you, just to get you going with one data type and how to access the data contained therein.
Apply what you know and learn what you don’t know in order to have a go at your project. Post back with your best effort and we’ll take it from there.
Yess im a beginner and im learning and thank you for your help…but in the above query i just made a toy dataset but in real there are many different random values(90000 rows) in all columns so how can i do this
One of the cool things about code is called ‘looping’. This basically means that once you get code to do one thing correctly, you can loop it to do the same thing as many times as you need it to.