Archive
Python Project: Properties Maintenance System P9
Subject: Writing a Full Application for Properties Maintenance System [Property: Delete a Record]
Learning : Python, Math, SQL, Logeic
[NOTE: To keep the code as simple as we can, We WILL NOT ADD any user input Varevecations. Assuming that our user will Enter the right inputs.]
In this part we will write a Function to Edit a record on the database, first we will call the def show_property(inside) to display all the records on the screen and ask the user to Select [enter] the ID of the Property to be Edited. Next we will Display the Record again on the screen and ask the user to Confirm the Editing by entering [Y] and any things else will be as [Don’t Edit]. Here is the code ..
|
Next we will ask the user about each attributes in the system, so the user will enter the new data (update the current one) or just press enter to keep the existed data. Here is a part of the code ..
 |
After That we will check on each user input for the attributes, if the user change/Edit the data [did not press enter] then we run an SQL command to alter the database. Here are part of the code we use ..
 |
Now we have an updated record, so we will show a message to inform the user that the records been updated.
NOTE: If you Download this Part you MUST Run the Option 82 (82. Delete the Data-Base and Start Again.) from the Main Menu to do the following Updates:
- Updates some attributes in the Database Level.
## Highly Recommended ##
In Part-10 the Next Part, we will add the Function to Backup our data .
:: PMS Parts ::
| Part 1 | Part 2 | Part 3 | Part 4 |
| Part 5 | Part 6 | Part 7 | Part 8 |
| Part 9 | Part 10 | Part 11 | Part 12 |
..:: Have Fun with Coding ::.. 🙂
To Download my Python code (.py) files Click-Here
Follow me on Twitter..By: Ali Radwani
Arduino: First App
Learning : Arduino Projects, Arduino Coding, Electronic Circutes
Subject: First Application, Light the LED
[NOTE: We are working on Electronic Devices, Voltage, Resistors and other Electronic Parts that may Become HOT due to un-stable current or Wrong Wire Connections.. PLEASE BE CAUTIOUS AND TAKE SAFETY NEEDED PROCEDURES.]
The Task: In our First Application on ARDUINO we will write a code to Light ON then OFF an LED or say Two Led’s each will go On and Off for several time to show a Blinking light.
What We Need: We will try to be simple on our first project, we will put the Led’s on a braedboard connected to ARDUINO Nano (Any other Arduino Chip can be use). So, we will use Arduino-Board, BreadBoard, Two resistors and tow Led light (I will use One Red, and One Green).
Set-up: We will connect the Red-Led on Pin A3, and the Green-Led on Pin D12, the ARDUINO-Board will take power from it’s USB cable connected to the Laptop.
Coding: The Application will make the Led’s to BLINK in some sequence.
# CODE: Function to turn led On, wait for some delay-time and Turn it off. Two Led's (Red, Green) Blinking
const int red_led = A3 ; // set pin A3 for red-led.
const int green_led = D12 ; // set pin D12 for green-led.
void setup()
{
pinMode(red_led, OUTPUT);
pinMode(green_led, OUTPUT);
}
void led_on_off (int led, int dt) // Function to Turn led On Wait for delay = dt then turn it off.
{
digitalWrite(led, HIGH);
delay(dt) ;
digitalWrite(led, LOW);
delay(dt) ;
}
void loop ()
{
// in both for-loops, change the delay and/or numbers to have different lighting sequences.
for (int R = 0; R < 3; R ++) //loop for Red-Led
{
led_on_off(red_led, 300);
for (int G = 0; G < 2; G ++ ) //loop for Green-Led
{
led_on_off(green_led,110) ;
}
}
exit(0) ; // To stop the action after executing One-Time.
}
Image of set-up and Running ..
|
GIF of the Out-Put |
I am not sure if i will continue in this way or say “New Learning Curve”, The Coding and Commanding an Electronic-Bord to Work as my Application says .. THIS PART WAS WHAT LIT THE FUSE IN MY BRAIN.
:: ARDUINO PROJECTS LIST ::
| 3 | First Application |
| 2 | Code Editor, coding Blocks, learn Coding |
| 1 | Arduino, The Story, Components, Parts and What we will Do? |
To Download the ARDUINO Project [Code and Diagram] files Click-Here
By: Ali Radwani
Python Project: Properties Maintenance System P8
Subject: Writing a Full Application for Properties Maintenance System [Property: Delete a Record]
Learning : Python, Math, SQL, Logeic
[NOTE: To keep the code as simple as we can, We WILL NOT ADD any user input Varevecations. Assuming that our user will Enter the right inputs.]
In this part we will write a Function to Delete a record from the database, first we will call the def show_property(inside) to display all the records on the screen and ask the user to Select [enter] the ID of the Property to be Deleted. Next we will Display the Record again on the screen and ask the user to Confirm the Deleting by entering [Y] and any things else will be as [Don’t Delete]. Here is the code ..
 |
.. End of Part 8 ..
NOTE: If you Download this Part you MUST Run the Option 82 (82. Delete the Data-Base and Start Again.) from the Main Menu to do the following Updates:
- Update the properties_t Table (Adding the number of BathRooms)
- Update on create_tables Function.
- Update on insert_zero_records Function.
If you did this in last part (6) then you don’t need to do it again
In Part-9 In the Next Part, we will write the Function to Edit a record of a selected Property.
:: PMS Parts ::
| Part 1 | Part 2 | Part 3 | Part 4 |
| Part 5 | Part 6 | Part 7 | Part 8 |
..:: Have Fun with Coding ::.. 🙂
To Download my Python code (.py) files Click-Here
By: Ali Radwani
Python Project: Properties Maintenance System P7
Subject: Writing a Full Application for Properties Maintenance System [Property: Showing the Records in Main property Table]
Learning : Python, Math, SQL, Logeic
[NOTE: To keep the code as simple as we can, We WILL NOT ADD any user input Varevecations. Assuming that our user will Enter the right inputs.]
After adding Records to the Main Property Table, we need to display the records on the screen. So now in this part (Part -7) we will write a function to display all the records. The Function name will be def show_property() the function is not taking any attribute and is Not returning any things. First we will print-out the Table-Header then we will run an [SQL: select * from table-name] command to fetch all the records, then will [for loop] and test-format to print all the records on the screen. Here is the Code ..
 |
After i display the records, I notes that the Address-Column needs more than one row (in some cases), and it miss the line formating, so I wrote a function and call it def warp_text(tex,warp_on,nl_space) the function takes three arguments, the test: it the text/string you want to print.warp_on: is a number of character before the new-line.nl_space: is the number of white-character in the new-line.
Here is the Code ..
# Function to warp
def warp_text(tex,worp_on,nl_space) :
c = 0
for t in range (len(tex)) :
print(tex[t],end="")
c += 1
if c == worp_on :
print('\n', ' '*nl_space, end="")
c = 0
Check all the codes in the Download Page..
End of Part 7
NOTE: If you Download this Part you MUST Run the Option 82 (82. Delete the Data-Base and Start Again.) from the Main Menu to do the following Updates:
- Update the properties_t Table (Adding the number of BathRooms)
- Update on create_tables Function.
- Update on insert_zero_records Function.
If you did this in last part (6) then you don’t need to do it again
In Part-8 In the Next Part, after adding and showing the records we will write the Function to Delete a record from the Table.
:: PMS Parts ::
| Part 1 | Part 2 | Part 3 | Part 4 |
| Part 5 | Part 6 | Part 7 | Part 8 |
..:: Have Fun with Coding ::.. 🙂
To Download my Python code (.py) files Click-Here
By: Ali Radwani
Python: Coffee Consumption P10
Learning : Python, SQlite3, Dataset, Pandas,
Subject: Create Coffee Consumption Application.
[NOTE: To keep the code as simple as we can, We WILL NOT ADD any user input Varevecations. Assuming that our user will Enter the right inputs.]
[ IF THE IS FIRST TIME DOWNLOADING THE CODE FILE, SELECT OPTION 7 FROM MAIN-MENU TO CREATE THE DATABASE]
In this Last part (Part-10) of Coffee Consumption App, we will write a Function to Export the Data to an Excel Fiel, So this will be the Last part of this application and any other Enhancement will be added as new version of the application.
Exporting The Data: To Export the data to or say “writing into” Excel file we need to import New library Named: xlsxwriter [if you don’t have the library then you need to install it first, using this command: pip install xlsxwriter]. After installing we will call it into our python file using this command: import xlsxwriter. The Excel file [in this case] will have four Sheets, named as follow:
coffee_con, coffee_name, coffee_type, coffee_size
each sheet will contains the table header and the date.
File Name: The file name will be as: coffee_consumption_[Current Date & Time].xlsx, the date and time will be formated as: yyyymmdd_HM, the python code to generate this is:
now = datetime.now()
date_t = now.strftime(“%Y%m%d_%H%M”)
Also we need to know that the file will be saved in the same directory of the application or (python .py file)
New Function: from our back_up function we will call another Function called: write_data(data_set,col_list,the_sheet): this Function will write the data-set into Excel file sheet, so we need to pass the data_set, column list and the Sheet Name as arguments to the function and it will use the command: write(row,col,data) to write the row to the sheet. Here is the code
# Writing the data into the sheet
def write_data(data_set,col_list,the_sheet):
"""
Function to write the data-set into Excel file sheet.
Argument:
data_set:
col_list: List of the columns in the data_set.
the_sheet: the Sheet Name.
"""
# write the Table Header
for x in range (0,len(col_list)):
the_sheet.write(0,x,col_list[x])
rows = len(data_set)
for row in range (1,rows) :
for col in range (0,len(col_list)) :
the_sheet.write(row,col,data_set[row][col])
In our main back-up function, we prepare the data-set and column list, then we call the new Function write_data passing the variable. Here is two parts of the code, first one is generating the file name, and calling the datetime function, second part is dealing with the data tables in the database, fetching the data, listing the columns and passing this to write_data function.. Here is the code
 |
 |
… Done. We finish the Coffee Consumption Application using Python and Sqlite. Next Week we will start New Application ..
..:: Have Fun with Coding ::.. 🙂
| Part 1 | Part 2 | Part 3 | Part 4 | Part 5 |
| Part 6 | Part 7 | Part 8 | Part 9 | Part 10 |
To Download my Python code (.py) files Click-Here
By: Ali Radwani
Old Drawer: Nikon S9900 # 11
Title: Nikon S9900 # 11
Subject: Drawer Side with Nikon S9900
This Shot: In one of my indoor photo-session i take this shot of an old drawer in my living room, using Black and White option, lights coming from the window & Camera in hand
…Click Image to Enlarge… Camera in Hand, F:4 , ISO:400 , Shutter:1/10s Focal-Point:6mm
|
::.. To see all my Nikon S9900 Photos Click-Here
::.. To see all my Nikon D7100 Photos Click-Here
::.. To see all my Nikon D90 Photos Click-Here
By: Ali Radwani
30 day of ML with Kaggle
Last week during some search on YouTube, I fond a Two Minutes video talking about a new course on Kaggle that will start on 2nd of August, the Course is about Machine Learning ML with Python in a 30 Day’s. I was not sure if it is Free or Not, later on I fond that it is FREE, so I register to it.
And as a part of the program, we will complete three courses: Python, Intro to Machine Learning, and Intermediate Machine Learning.
My time is very tight, and I don’t know if I can continue to complete the required stages/assignments on time for each stage of the program.. Sure I will Try my best.
Now, I am writing this post in 3rd of August 2021, 6:00pm (GMT+3) .. First want to say they did not start on time, delay 1 day! so today was Day 1 , we start with introduction on Kaggle, the participate in first competition and submitting our solution.
I will try to summarize and drop a post every two-three days .. or so ..
:: Have Fun .. Code with Python ..::
Ali,
Python Sorting Algorithm – Heap Sorting -P4
Learning : Python, Math, Algorithm
Subject: Sorting Algorithm, Heap Sort P2
[NOTE: To keep the code as simple as we can, We WILL NOT ADD any user input Varevecations. Assuming that our user will Enter the right inputs.]
In Last Parts (2 & 3) we wort the Following Functions:
- Sections Header.
- Main Menu Function.
- Entering/Creating the Array.
- Print-Out or to Display the Array.
- Check If Array in Max-Heap.
- Convert Array to Max-Heap.
In this Part-4 we will cover another Two important Functions that we need to talk about in our mission to understand the Heap Sorting Algorithm. In a Max-Heap Array we may need to Add new Node to the Array and we may need to Delete a Node. Also I just add Item No.7 style=”color:#2662ee;”>print(‘ ‘*5,’ 7. Start Heap Sorting.’) to the main-menu so we can do Heap Sorting to a given Array.
Starting with Add New Node, Simply we Add the Node to the end of the Array using arrat.append(new_node) then we need to Check If still the Array in Max-Heap If NOT, We MUST Convert it to a Max-Heap.
Scope of Work Ask the user to Enter the New Node Value, Add The Node to the End of the Array, in While Loop Call convert_to_max_heap (arr,True), check_if_max_heap (arr,True) as following:
while not is_max:
arr = convert_to_max_heap (arr,True)
is_max = check_if_max_heap (arr,True)
this will keep check and convert the Array to Max-Heap. Here is the Full code and run screen ..
 |
 |
Now we will write a Function to Delete a Node from the Max-Heap Array. Deleting a Node is just by removing the first node in the Array (Array[0]), then moving the last element in the Array to it’s position, by doing this we may not having a Max-Heap Array any-more, so we need to convert the array to a Max-Heap. In our application here, we will have a while loop and calling the functions (check_if_max_heap and convert_to_max_heap) until we have the Array in a Max-Heap. Here is the code ..
 |
We will stop here in this part. In Part-5 we will Sort any Array using the Max-Heap Sort Algorithm.
..:: Have Fun with Coding ::.. 🙂
To Download my Python code (.py) files Click-Here
Follow me on Twitter..By: Ali Radwani
Sketch: Crane Bird Landing
Here is another sketch using pencil & black ink pen to sketch a Crane Bird Landing on the shores of a Lake. I am sketching to improve my skill .. 🙂
 |
By: Ali..
Follow me on Twitter: @h_ta3kees
Python Sorting Algorithm – Heap Sorting -P3
Learning : Python, Math, Algorithm
Subject: Sorting Algorithm, Heap Sort P2
[NOTE: To keep the code as simple as we can, We WILL NOT ADD any user input Varevecations. Assuming that our user will Enter the right inputs.]
First let’s just remember that in Part-1 we wort the Following Functions:
- Main Menu Function.
- Entering/Creating the Array.
- Print-Out or to Display the Array.
- Sections Header.
In this Part-3 we will cover another Two important Functions that we need to talk about in our mission to understand the Heap Sorting Algorithm.
First Function
Check If The Array is in Max Heap: After the user Giveing/Entering the Array [Selecting Option 1 in the Menu] we need to Examen/Check if it is in a Max-Heap, to do so we will call the Function def check_if_max_heap(arr, inside): the Function will take Two arguments:
arr : The Array.
inside: Boolean Flag showing are we calling the Function from within another Function or Not.
Scope of Work: We will check and compare each Node [starting from last node in the leaves] with it’s Parent using this formula parent_index = ((child_index-1)//2) to get the parent index, then comparing the Values of the Child and Parent, If the Child is GRATER Than his Parent we SWAP them. Then going to the Next Child and so-on until the Root-Node. .. Here is the Code ..
|
for each print statement I am using this code if not inside : then print ..
Example: if not inside : print(‘\n The Array is a Max-Heap Array.’)
So if the inside = True then the print code will not work, that’s mean we are calling the Function from inside another function and we just want the return value, the return here will be a boolean True/False as is_max [if the array is in Max-Heap].
Second Function
Convert to Max-Heap: In this Function we will convert a given Array to a Max-Heap Array. The way this Function is working is by checking/Examining all the Childs starting from the Leaves, and if any Child is Grater than his Parent we do a SWAP. After we Finish, we will call the Function def check_if_max_heap(arr, inside): to check if the Array is in Max-Heap, If NOT we will call the convert Function and so-on until we get the is_max = True from the def check_if_max_heap(arr, inside):. Both Functions def check_if_max_heap(arr, inside): and def convert_to_max_heap (arr,inside): will be run in a while loop until def check_if_max_heap(arr, inside): will return True. .. Here is the code for def convert_to_max_heap (arr,inside):
|
And here is the while loop to keep Examining the Array until fully converted to a Max-Heap Array.
# While loop in Option 3 from the Main-Menu, In the main body code..
while not is_max:
arr = convert_to_max_heap (arr,True)
is_max = check_if_max_heap (arr,True)
We will stop here in this part. In Part-4 we will Add new Node to the Array, and Delete a Node from the Array.
..:: Have Fun with Coding ::.. 🙂
To Download my Python code (.py) files Click-Here
By: Ali Radwani
Taking pictures is not my main daily practices, but when i start playing with my camera, i really enjoy my self.
Thanks for visiting my Space..
Ali's Photography Space... 