Posts

Solved: ValueError if using all scalar values, you must pass an index

FIIsTurnover = {'Category': 'FII', 'Trade Date': '17-Jul-2020', 'Buy Value in Rs.': '4287.52', 'Sell Value in Rs.': '5477.05', 'netValue': -1189.5299999999997} df = pd.DataFrame(FIIsTurnover) Result: ValueError: If using all scalar values, you must pass an index Correct Code: df = pd.DataFrame([FIIsTurnover]) Result:   Buy Value in Rs. Category Sell Value in Rs.   Trade Date  netValue 0          4287.52      FII           5477.05  17-Jul-2020  -1189.53 Note: Data should be like, FIIsTurnover = {'Category': ['FII'], 'Trade Date': ['17-Jul-2020'], 'Buy Value in Rs.': ['4287.52'], 'Sell Value in Rs.': ['5477.05'], 'netValue': ['-1189.5299999999997']} df = pd.DataFrame.from_dict(FIIsTurnover)

Solved - ValueError: invalid literal for int() with base 10:

amount = '10,000' # Convert to integer amount_to_int = int(amount) ValueError: invalid literal for int() with base 10: '10,000' Solution: amount = '10,000' # Convert to integer amount_to_int = int(amount.replace(',','')) print(amount_to_int)

Solved - OSError("(10060, 'WSAETIMEDOUT')" in Requests package in Python

Code which return error import json import requests url = 'https://www1.nseindia.com' r = requests.get(url) print (r.text) Error Traceback (most recent call last):   File "D:\PythonLearn\lib\site-packages\urllib3\connectionpool.py", line 601, in urlopen     chunked=chunked)   File "D:\PythonLearn\lib\site-packages\urllib3\connectionpool.py", line 387, in _make_request     six.raise_from(e, None)   File "<string>", line 2, in raise_from   File "D:\PythonLearn\lib\site-packages\urllib3\connectionpool.py", line 383, in _make_request     httplib_response = conn.getresponse()   File "D:\PythonLearn\lib\http\client.py", line 1331, in getresponse     response.begin()   File "D:\PythonLearn\lib\http\client.py", line 297, in begin     version, status, reason = self._read_status()   File "D:\PythonLearn\lib\http\client.py", line 258, in _read_status     line = str(self.fp.readline(_MAXLINE + 1), "...

JIRA and Testing

JIRA basic 6 steps 1. Create a project 2. Select a template - scrum - used for sprint wise task - kanban - track the Epics status release wise 3. Setup board 4. Create issues - will go in backlogs - Initiative - are collections of epics that drive toward a common goal. - Epic - an “epic” is a large body of work that can be broken down into smaller Stories and not completed in a sprint. - Story - Stories further divided into tasks, QA, Spike. Stories are distributed in multiple sprints - Task - Digging down the story in small tasks. All tasks in a story sould be completed in a sprint. Many subtasks can be created under tasks - Bug - Defect reporting - QA - QA tasks - Automation code for E2E test. Completed in a sprint - Spike - To take knowledge - Investigation - Troubleshooting 5. Invite your team 6. Setup my workflow - To Do - In Progress - In Testing - In Review - Done Reports - Burndown chart - Sprint report

Project Management & Team Lead Q&A

Q: What's your current role and responsibilies? I have played a offshore team lead role when we had the seperate QA board. I managed a team of 4 people. My roles and resonsibilities were to co-ordinate with onsite team lead to discuss the PI objectives and communicate the team so that they can ramp up with the knowledge of new features and fixes. I do participate in each sprint planning to estimate the tasks and define story points according to the velocity of resources and discussion on the scope of testing. Now I do assign the tasks within the team accordingly. Also, I come up with a plan and helping the team if we are lacking to achieve the target. In case still we are lacking to complete the task, I co-ordinate the onsite team lead who further update to srrum master. Also, I try to rotate the features among the team members to avoid any dependency of a resource. I do arrange the KT sessions once we have lien time. Now, we all are moved to a common board so I am working as ...

DVB Q&A

Image
- Headend workflow including transmission MUX - A2B, Harmonic,Tandburg Encoder - Harmonic, Tandburg EN8030 IRD - Tandburg RX-1290 STB - Kaon Middleware - Any SMS intergrated with VCAS OMI - EMM and ECM persists in which PSI table? EMM in CAT ECM in PMT - How DVB works? - Why simulcrypt is used because of multiple conditional access systems can be used at the same time which saves bandwidth. - Architecture of STB? Transmission Parameters given to tune the channels: Downlink Frequency Polarization Symbol rate - What is the use of STB middleware Parsing and version monitoring of SI/PSI tables Support for full & manual scan and detection of new channels Three lists maintained: one each for TV, radio and data services Middleware with caching methods (e.g., EPG buffer manager) helping to minimize memory consumption Maintaining of system time by parsing TDT/TOT tables - MPEG functional diagram - TS Packet Size of pack...

Comprehensive guide to Matplotlib

Image
=> Simple plot with 2 axis from matplotlib import pyplot as plt age_x = [25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35] dev_y = [38496, 42000, 46752, 49320, 53200,          56000, 62316, 64928, 67317, 68748, 73752] plt.plot(age_x, dev_y) plt.show() => Simple plot with 2 axis with xlabel, ylabel and title from matplotlib import pyplot as plt age_x = [25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35] dev_y = [38496, 42000, 46752, 49320, 53200,          56000, 62316, 64928, 67317, 68748, 73752] plt.plot(age_x, dev_y) plt.xlabel("Age") plt.ylabel("Median Salary (USD)") plt.title("Median Dev Salary (USD) by Age") plt.show() => Plot multi-dimentional data from matplotlib import pyplot as plt age_x = [25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35] dev_y = [38496, 42000, 46752, 49320, 53200,          56000, 62316, 64928, 67317, 68748, 73752] plt.plot(age_x, dev_y) py_dev_y = [45372, 48...