Here are all the codes written by me while learning DSA basics implementation.
Revising what has been done yet
https://www.markdownguide.org/basic-syntax/
https://www.interviewbit.com/data-structure-interview-questions/
couldn't do much, just explained the various branches of Software Engineering to Shubhi.
interviewbit DS interview questions will go for some days may be, I'll try to finish it by this weekend. Today is Tuesday.
DS is how data and the relationship amongst different data is represented, that aids in how efficiently various functions or operations or algorithms can be applied.
two types of data structures:
Linear : Arrays, Linked Lists, Stack, Queues
Non-Linear : Tree, Graph, Table, Set
a problem is constrained by the space and time complexity within which it has to be solved efficiently.
The implementation in procedural languages like C is done with the help of structures, pointers, etc.
In an objected oriented language like Java, data structures are implemented by using classes and objects.
1.Can you explain the difference between file structure and storage structure?
File Structure: Representation of data into secondary or auxiliary memory say any device such as hard disk or pen drives that stores data which remains intact until manually deleted is known as a file structure representation.
Storage Structure: In this type, data is stored in the main memory i.e RAM, and is deleted once the function that uses this data gets completely executed.
The difference is that storage structure has data stored in the memory of the computer system, whereas file structure has the data stored in the auxiliary memory.
Best book to start with Python-
https://automatetheboringstuff.com/
Al Sweigart also has a YouTube channel and a course based on this book!
Google Tech Dev Guide
Stage 1 - https://techdevguide.withgoogle.com/paths/foundational/?programming_languages=python
Automating excel reports with https://openpyxl.readthedocs.io/en/stable/tutorial.html
SOLID principle in Object Oriented Programming https://www.digitalocean.com/community/conceptual_articles/s-o-l-i-d-the-first-five-principles-of-object-oriented-design
https://www.cyberciti.biz/faq/howto-save-ouput-of-linux-unix-command-to-file/
https://www.baeldung.com/linux/delete-lines-containing-string-from-file
1. Process flow <br>
2. Minutes of Meeting<br>
Additionally, get in the details of sql(creating table from excel) and python(pandas).<br>
Tip: Read SOPs and queries.<br>
Prepaid reports-> inserting data from csv to teradata table<br>
import os<https://docs.python.org/3/library/os.html><br>
import sys<https://docs.python.org/3/library/sys.html><br>
import teradataml<https://pypi.org/project/teradataml/><br>
to_sql in prepaid report-> inserting data from csv to teradata table<br>
https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.to_sql.html
create_context()
https://docs.teradata.com/r/Teradata-Python-Package-User-Guide/February-2020/Context-to-Teradata-Vantage
read_csv()
https://pandas.pydata.org/docs/reference/api/pandas.read_csv.html
DataFrame.columns --> The column labels of the DataFrame.
from teradataml.dataframe.copy_to import copy_to_sql
https://docs.teradata.com/r/Teradata-Python-Package-User-Guide/February-2020/teradataml-General-Functions/Save-DataFrames-to-Vantage/copy_to_sql-Method