How to create a table with clickable hyperlink in pandas & Jupyter Notebook

by

If you want to apply URL formatting only to a single column, you can use:

data = [dict(name="Google", url="http://www.google.com"),
        dict(name="Stackoverflow", url="http://stackoverflow.com")]
df = pd.DataFrame(data)

def make_clickable(val):
    # target _blank to open new window
    return '<a target="_blank" href="https://stackoverflow.com/questions/42263946/{}">{}</a>'.format(val, val)

df.style.format({'url': make_clickable})

(PS: Unfortunately, I didn’t have enough reputation to post this as a comment to @Abdou’s post)

More Related Contents:

  1. Show DataFrame as table in iPython Notebook
  2. Jupyter notebook display two pandas tables side by side
  3. How can I left justify text in a pandas DataFrame column in an IPython notebook
  4. How to provide a reproducible copy of your DataFrame with to_clipboard()
  5. How to split data into 3 sets (train, validation and test)?
  6. Pandas bar plot changes date format
  7. Export from pandas to_excel without row names (index)?
  8. Pandas – Find and index rows that match row sequence pattern
  9. After rename column get keyerror
  10. Trouble installing Pandas on new MacBook Air M1
  11. Pandas, group by count and add count to original dataframe?
  12. using time zone in pandas to_datetime
  13. Python/Pandas: counting the number of missing/NaN in each row
  14. Kalman filter with varying timesteps
  15. pandas dataframe group and sort by weekday
  16. Merge two data frames based on common column values in Pandas
  17. Why does it take ages to install Pandas on Alpine Linux
  18. Pandas: convert date in month to the 1st day of next month
  19. Splitting multiple columns into rows in pandas dataframe
  20. Getting Colorbar instance of scatter plot in pandas/matplotlib
  21. All possible combinations of columns in dataframe -pandas/python
  22. Why are Pandas and GeoPandas able to read a database table using a DBAPI (psycopg2) connection but have to rely on SQLAlchemy to write one?
  23. Format a number with commas to separate thousands
  24. Pandas & AWS Lambda
  25. Scrape tables into dataframe with BeautifulSoup
  26. How to remove illegal characters so a dataframe can write to Excel
  27. Turn pandas dataframe into a file-like object in memory?
  28. concise way of flattening multiindex columns
  29. use Featureunion in scikit-learn to combine two pandas columns for tfidf
  30. Convert dataframe with start and end date to daily data

Leave a Comment