Skip to content

achoudh5/Manipulating_Excel_Sheet

Repository files navigation

Huge Shout Out 👏

GitHub labels

The person who owns this repo is mere face of it, it's you who are making a difference! Keep contributing :) Please make a comment if you see I am missing any tag or label which might miss your contribution, I don't want that to happen that was the whole point.

GitHub closed pull requests GitHub issues

Change the state of your Issue (keep it professional)

Join my ZenHub

Add Plugin Zenhub

Manipulating_Excel_Sheet 📁

  • Being a Network Security Professional, I am currently working on this exciting project which makes the NetOps work easy
  • Challenge is to make the users use a tool which is easy to navigate considering they don't have software mindset!
  • Think like a Noob, there are no assumptions for this project :)
  • Convey your message with minimal Knowledge transfer
  • I am all ears to suggestions, don't hesitate to suggest

All files below are samples only

The name and position of columns will be same, don't worry about it but it would be great if you can identify the heading from row 1 and use from that perspective

There might be case where the Hacktobefest_Expected_Output.xlsx might have colors which don't precisely map to Hacktoberfest_database.xlsx (I tried a sample, please bare with this for now. I'll update precisely the correct colors. Incase you understand the requirements, feel free to grab the issues)

Hacktoberfest_Inputt.xlsx

Hacktoberfest_Expected_Outcome.xlsx

Hackoberfest_Database.xlsx

Sample of how zip.py is working currently

  • Each Arrow represents anomaly from expected output (check below image)

  • Each number represents an issue faced, you can create an issue and raise a PR!

Currently

Expected of zip.py

Expected

Sample Expectation of GUI

Sample_Gui

Current GUI using tKinter on Windows and MAC

Windows GUI

Curr-Wind

Curr-Win

MAC GUI (Needs Help)

Current-MAC

Guide to Github & Git:

Make sure you have a GitHub account. In case you don't have one, you can create your account by visiting https://github.com/ and clicking on Sign up option at the top right corner.

1. Register yourself for Hacktoberfest

Click on "Start Hacking" and add your GitHub account.

Screenshot (16)

2. Star and Fork this Repository

You can star and fork this repository on GitHub by navigating at the top of this repository.

GitHub repository URLs will reference both the username associated with the owner of the repository, as well as the repository name. For example, acmbvp is the owner of the Hacktoberfest repository, so the GitHub URL for this project is:

https://github.com/achoudh5/Manipulating_Excel_Sheet

When you’re on the main page of a repository, you’ll see a button to "Star" and “Fork” the repository on the upper right-hand side of the page, underneath your user icon.

Screenshot (17) Screenshot (22)

3. Clone the Repository

To make your own local copy of the repository you would like to contribute to, let’s first open up a terminal window.

We’ll use the git clone command along with the URL that points to your fork of the repository.

This URL will be similar to the URL above, except now it will end with .git. In the cloud_haiku example above, the URL will look like this: https://github.com/achoudh5/Manipulating_Excel_Sheet.git

You can alternatively copy the URL by using the green “Clone or download” button from your repository page that you just forked from the original repository page. Once you click the button, you’ll be able to copy the URL by clicking the binder button next to the URL:

Screenshot (23)

Once we have the URL, we’re ready to clone the repository. To do this, we’ll combine the git clone command with the repository URL from the command line in a terminal window:

git clone https://github.com/your-username/Manipulating_Excel_Sheet.git

4. Create a New Branch

To create your branch, from your terminal window, change your directory so that you are working in the directory of the repository. Be sure to use the actual name of the repository (i.e. Manipulating_Excel_Sheet) to switch into that directory.

cd Manipulating_Excel_Sheet

Now, we’ll create our new branch with the git branch command. Make sure you name it descriptively so that others working on the project understand what you are working on.

git branch new-branch

Now that our new branch is created, we can switch to make sure that we are working on that branch by using the git checkout command:

git checkout new-branch

Once you enter the git checkout command, you will receive the following output:

Output:
Switched to branch 'new-branch'

At this point, you can now modify existing files or add new files to the project on your own branch.

Make Changes Locally

Once you have modified existing files or added new files to the project, you can add them to your local repository, which you can do with the git add command. Let’s add the -A flag to add all changes that we have made:

git add -A or git add .

screenshot 155

Next, we’ll want to record the changes that we made to the repository with the git commit command.

The commit message is an important aspect of your code contribution; it helps the other contributors fully understand the change you have made, why you made it, and how significant it is. Additionally, commit messages provide a historical record of the changes for the project at large, helping future contributors along the way.

screenshot 155

If you have a very short message, you can record that with the -m flag and the message in quotes:

Example:
git commit -m "Updated Readme.md"

screenshot 156

At this point you can use the git push command to push the changes to the current branch of your forked repository:
Example:
git push --set-upstream origin new-branch

5. Update Local Repository

While working on a project alongside other contributors, it is important for you to keep your local repository up-to-date with the project as you don’t want to make a pull request for code that will cause conflicts. To keep your local copy of the code base updated, you’ll need to sync changes.

We’ll first go over configuring a remote for the fork, then syncing the fork.

6. Configure a Remote for the Fork

Next up, you’ll have to specify a new remote upstream repository for us to sync with the fork. This will be the original repository that you forked from. you’ll have to do this with the git remote add command.

git remote add upstream https://github.com/achoudh5/Manipulating_Excel_Sheet.git

screenshot 74

In this example, // upstream // is the shortname we have supplied for the remote repository since in terms of Git, “upstream” refers to the repository that you cloned from. If you want to add a remote pointer to the repository of a collaborator, you may want to provide that collaborator’s username or a shortened nickname for the shortname.

7. Sync the Fork

Once you have configured a remote that references the upstream and original repository on GitHub, you are ready to sync your fork of the repository to keep it up-to-date.

To sync your fork, from the directory of your local repository in a terminal window, you’ll have to use the // git fetch // command to fetch the branches along with their respective commits from the upstream repository. Since you used the shortname “upstream” to refer to the upstream repository, you’ll have to pass that to the command:

git fetch upstream

Switch to the local master branch of our repository:

git checkout master

Now merge any changes that were made in the original repository’s master branch, that you will access through your local upstream/master branch, with your local master branch:

git merge upstream/master

8. Create Pull Request

At this point, you are ready to make a pull request to the original repository.

Navigate to your forked repository, and press the “New pull request” button on your left-hand side of your Repo page.

No contribution is small,don't forget to update Contributing.md file

Raise a PR 🚀 and get Hacktoberfest 2020 T-Shirt 😄

Thank you for your contribution 👏

Do Star ⭐ this repository